This component enables OutSystems applications to convert Excel (.xlsx) and CSV (.csv) files into JSON format entirely offline using the SheetJS library. It is designed to be lightweight, efficient, and fully client-side, making it ideal for applications that need to process spreadsheet data without relying on server-side services or external APIs.

Key Features

1. Multi-sheet Support
   The component can read all sheets in an Excel workbook and return each sheet’s data as a separate key in the JSON object. This allows you to handle workbooks with multiple datasets easily.

2. CSV Support
   It can also process CSV files, treating them as a single-sheet workbook for conversion to JSON.

3. Optional Header Handling
   The HasHeader input allows you to specify whether the first row should be treated as column headers.

   • If HasHeader = true, each row is converted to a JSON object with key-value pairs based on the header names.

   • If HasHeader = false, each row is returned as an array of values.

4. Offline Operation
   The component runs entirely in the browser, so no internet connection or server processing is required. It uses the SheetJS library embedded in the module and does not rely on external CDNs.

5. Consistent JSON Output

   • With headers:

     {
       "Sheet1": [
         {"Name": "John", "Age": 30},
         {"Name": "Anna", "Age": 25}
       ]
     }
     

   • Without headers:

     {
       "Sheet1": [
         ["Name","Age"],
         ["John",30],
         ["Anna",25]
       ]
     }
     

6. Easy Integration
   Simply provide the file as a binary input and specify whether it has headers. Call the ConvertSpreadsheetToJson action and receive the structured JSON output ready for use in your application logic.

Use Cases

• Importing user-uploaded Excel files in web applications

• Processing CSV exports from other systems

• Transforming spreadsheet data into JSON for APIs or data processing

• Offline spreadsheet handling for mobile or reactive apps