Setup 

This component includes three libraries:

• Papa Parse v5.4.1 – https://github.com/mholt/PapaParse
• SheetJS xlsx.js v1.15.0 – https://sheetjs.com
• Excel2List – Custom script.
  
  

To implement this component in your application, you must include the following three scripts as dependencies: Excel2List, papaparse_min, and xlsx_full_min. These should be added as required scripts at the desired level (screen or module), depending on your needs.

You must also add the Excel2List_Client Client Action as a dependency (this includes the Column structure).

Usage

To use the component, invoke the Client Action and provide the following required parameters:

• ExcelFile (Binary) → The .XLSX or .CSV file.
• SheetName → The name of the sheet (not applicable for .CSV files).
• Columns → The Excel columns to be extracted.
  
  

After processing the file, the following outputs are returned:

• RowAsText → List of rows in JSON format.
• RowsCount → Number of rows converted.
• Success → True/False (indicates whether processing succeeded).

Defining Columns

To define the columns, create a local variable of type Column List. Then, using a method such as ListAppendAll, add each column with its corresponding:

• Name (must match exactly, including spaces and case sensitivity)
• Expected data type in OutSystems

Currently, the following data types are supported:

• "Text"
• "Decimal"
• "Date"

The ColumnType attribute defaults to "Text", so specifying it is optional.

Converting the Response

To convert the response into a list, perform a JsonDeserialize on the output parameter and use a custom structure (list type) with the same fields as the requested columns.

Make sure that the Name in JSON attribute of each structure field exactly matches the column name, including spaces and case sensitivity (refer to the demo if needed).

For more details, please refer to this component’s demo or the live preview.