Is xlsb format reable now?

CloverDX Platform
1

how to read xlsb data?
i saw a topic from 2020, ur replys are is considered as furture funktion, is that possible now?

2

Hi,

Unfortunately, CloverDX does not have native functionality to read XLSB files. As XLSB support is rarely requested, it is not currently planned for future improvements.

As a workaround, we recommend converting XLSB files to XLSX or CSV. This can be done in CloverDX by leveraging LibreOffice’s command-line capabilities in combination with the ExecuteScript component. Here’s how you can set it up:

  1. Install LibreOffice
    Download and install LibreOffice from its official website.

  2. Add LibreOffice to Your PATH
    On Windows:

  • Locate the LibreOffice installation directory (usually C:\Program Files\LibreOffice\program).

  • Add this directory to your system’s PATH environment variable. This allows you to use the soffice command in any terminal.

    On Linux:

  • LibreOffice is typically installed in /usr/bin or /usr/lib/libreoffice/program. If it’s already in your PATH, you can use the soffice command directly.

  1. Use the following command to convert the XLSB file:

    soffice --headless --convert-to <output_format> --outdir <output_directory> <input_file>

    Example:

    soffice --headless --convert-to csv --outdir /path/to/output /path/to/input.xlsb

  2. Once converted to CSV, use a reader in CloverDX to process the file.

For reference, I’ve attached an example graph and an XLSB sample file to my reply to illustrate the process.
ExcelBinary.grf (3.8 KB)
xlbinary.xlsb (9.3 KB)

Best regards,
Tom