Excel to record list

Hi all,

I just want the user to be able to upload his excel file and the excel data appears in a table in the same screen. Excel file has the same headers in the table.

Thing is.. I don't know what to define in the "Upload" widget, client action, server action & ExcelToRecord List properties.

Can anyone explain in details plz.

mvp_badge
MVP
Solution

Hi Ahmad,

first you do not have option "ExcelToRecordList" and "RecordListToExcel" in client action

so you need to create a server action and take one input parameter as binary datatype and create a process for create record by exceltorecordlist

from client action you need to call this server action and pass binary data of file which you upload by widget.

Hope this will help you


Regards

Rahul Sahu

Exceltorecordlist.oml

Rahul Sahu wrote:

Hi Ahmad,

first you do not have option "ExcelToRecordList" and "RecordListToExcel" in client action

so you need to create a server action and take one input parameter as binary datatype and create a process for create record by exceltorecordlist

from client action you need to call this server action and pass binary data of file which you upload by widget.

Hope this will help you


Regards

Rahul Sahu

 Hi Rahul,
Thank you very much for your great response.. it's working like magic now!

 

Hi,

please check this document and video, where you will find everything:

Cheers


NOTE: This two documents explain the opposite case: How to Export Entity Data to Excel and How to customize the export to Excel

mvp_badge
MVP

welcome Ahmad.

cheers..


How to Read the excel two sheets in outsystems


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