Skip to content

Latest commit

 

History

History
58 lines (47 loc) · 4.15 KB

README.md

File metadata and controls

58 lines (47 loc) · 4.15 KB
Raw

POIFormulaExplorer

Table of Contents

  1. Features
  2. Prerequisites
  3. How to Build and Run
  4. Example Outputs

POIFormulaExplorer is a utility that lists supported and unsupported Excel formulas/functions for a given version of Apache POI, including functions from the Analysis ToolPak.

Features

  • Displays supported and unsupported functions for any Apache POI version.
  • Includes functions from the Analysis ToolPak.

Prerequisites

  • Java 11
  • Apache Maven

How to Build and Run

Step 1: Build the Project

To build the project for a specific Apache POI version, run the following Maven command, replacing poiversion with the desired POI version (e.g., 5.1.0 or 4.1.2):

mvn clean install "-Dpoi.version=poiversion"

Example:

mvn clean install "-Dpoi.version=5.1.0"

Step 2: Run the Application

After building the project, you can run it using the following command:

java -cp target/SupportedFunctions-1.0-SNAPSHOT.jar org.example.SupportedFunctions

Example outputs:

For POI version 5.1.0:

INFO  org.example.SupportedFunctions - Apache POI Version: 5.1.0
INFO  org.example.SupportedFunctions - Supported Functions: ABS, ACOS, ACOSH, ...
INFO  org.example.SupportedFunctions - Not Supported Functions: ABSREF, APP.TITLE, ...
INFO  org.example.SupportedFunctions - Analysis ToolPak Functions: AVERAGEIFS, BIN2DEC, ...

For POI version 4.1.2:

INFO  org.example.SupportedFunctions - Apache POI Version: 4.1.2
INFO  org.example.SupportedFunctions - Supported Functions: ABS, ACOS, ACOSH, ...
INFO  org.example.SupportedFunctions - Not Supported Functions: ABSREF, APP.TITLE, ...
INFO  org.example.SupportedFunctions - Analysis ToolPak Functions: BIN2DEC, COMPLEX, ...