apache / incubator-kie-drools

Drools is a rule engine, DMN engine and complex event processing (CEP) engine for Java.
http://www.drools.org
5.85k stars 2.49k forks source link

Feature Request: Add Support for LibreOffice Calc and Numbers Formats in DRL Parsers #6063

Open Rashmesh opened 4 weeks ago

Rashmesh commented 4 weeks ago

Feature Request: Add Support for LibreOffice Calc and Numbers Formats in DRL Parsers

Current Situation: The DRL parsers in the Apache Incubator KIE Drools project currently only support the XLS format for spreadsheets. This limitation presents two main issues:

  1. The supported XLS format is outdated, leading to frequent upgrade prompts.
  2. Users are restricted to using Microsoft Excel, a paid software solution.

Proposed Change: We propose expanding the DRL parsers' compatibility to include:

  1. LibreOffice Calc (https://www.libreoffice.org/discover/calc/)
  2. Apple Numbers (https://en.wikipedia.org/wiki/Numbers_(spreadsheet))

Rationale: Implementing support for these additional spreadsheet formats would bring several benefits:

  1. Increased Compatibility: Users would have more options for creating and editing spreadsheets compatible with DRL parsers.

  2. Wider User Base: By supporting open-source and alternative spreadsheet applications, we can attract users who prefer or are required to use non-Microsoft solutions.

  3. Cost Reduction: Removing the dependency on Microsoft Excel allows users to utilize free, open-source alternatives, potentially reducing software costs for individuals and organizations.

  4. Modern Format Support: This update would address the current issue of prompts to upgrade from the outdated XLS format.

  5. Cross-Platform Accessibility: LibreOffice Calc is available on multiple operating systems, while Numbers caters to the macOS and iOS ecosystems, broadening the project's reach.

Implementation Considerations:

I believe this enhancement will significantly improve the flexibility and accessibility of the Apache Incubator KIE Drools project, aligning it with modern spreadsheet usage patterns and open-source principles.