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.

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,

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

• Bootstrap an Entity Using an Excel File

Cheers

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

Rahul Sahu wrote:

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

welcome Ahmad.

cheers..