73
Views
4
Comments
Solved
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.

Rank: #89
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

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

Rank: #89

welcome Ahmad.

cheers..