How is your experience with the OutSystems Community?
16
Views
3
Comments
ExcelToRecordList widget is not visible in OutSystems 11. How can I convert an upload
Application Type
Reactive, Service
Service Studio Version
11.55.72 (Build 64874)

Hello,


I am working on an OutSystems 11 Reactive Web application.


I need to upload an Excel file using the Upload widget and convert the uploaded Excel data into a Structure List.


I found some forum posts and documentation mentioning an ExcelToRecordList widget/action, but I cannot find ExcelToRecordList in my module.


I checked Manage Dependencies and searched for:

- ExcelToRecordList

- Excel

- RecordList

- BinaryData


However, I could not find ExcelToRecordList


My plan is:


1. User uploads an .xlsx file using the Upload widget.

2. The Excel file has a fixed sheet and column layout.

3. I want to read the rows from the uploaded file.

4. I want to map each row to a Structure.

5. Then I want to insert the Structure List into an Entity using a Server Action.


Questions:


1. Is ExcelToRecordList still available in OutSystems 11?

2. If yes, which dependency/module should I add to use it?

3. Is ExcelToRecordList an action, a widget, or part of a specific component?

4. If ExcelToRecordList is not available in my environment, what is the recommended way to convert an uploaded Excel file into a Structure List?


For example, my Excel sheet has columns like:

SheetName : RequestList

- No

- CompanyCode

- SystemCode

- EmpNo

- UserName

- AuthId

- AuthName

- RequestType


I want to convert those rows into a Structure List like:


- UserAuthBulkUploadExcelRow List


Any guidance or sample flow would be appreciated.


Thank you.

2024-08-08 11-25-20
Santhosh Mathivanan

Hi,

Yes, ExcelToRecordList is still available in OutSystems 11. Please refer to the document and screenshot below.

OutSystems Documentation – Excel to Record List

 

2023-09-06 07-26-35
Sudip Pal

Hi,

This node is only available in Server Action. I think you are searching in Client Action.

2026-03-12 10-32-06
Wahaj Adil

hi @sangwoo jee , hope you're doing good. 
ExcelToRecordList widget is only available on server side calls when you use Server Action(s).

Thanks & regards!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.