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.
Hi,
Yes, ExcelToRecordList is still available in OutSystems 11. Please refer to the document and screenshot below.OutSystems Documentation – Excel to Record List
This node is only available in Server Action. I think you are searching in Client Action.
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!