Log in to AnswerLog in to Follow
2020-08-05 09-05-19
Ahmad Fathi
126Views
5Comments
Solved
Excel to record list
Question
New to OutSystems

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.

0
0
12 Jul 2020
2018-08-17 13-37-15
Rahul Sahu
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

1
0
12 Jul 2020

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!

 

1
0
13 Jul 2020

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

1
0
12 Jul 2020
2018-08-17 13-37-15
Rahul Sahu
mvp_badge
MVP

welcome Ahmad.

cheers..


1
0
13 Jul 2020

How to Read the excel two sheets in outsystems


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