Convert the .xlsb file into .xlsx extension

Problem Statement:

Attempts to convert .xlsb files into .xlsx format using a custom plugin were unsuccessful.

Suggested Approach:

To resolve this, a custom handler has been developed using the Apache POI API. This handler reads .xlsb files and converts them into .xlsx format.

Steps to Use the Solution:

1. Place the attached XSLB2XLSXConvertor.jar file into the ext folder.
2. Use the provided custom plugin CP_Convert_XSLB_to_XLSX.txt for the conversion process.
3. Restart the runtime environment after placing the compiled JAR in the ext folder.

Note:

The converter preserves the sheet structure and data from the source .xlsb file. However, it does not retain cell styles or formatting from the original file.