Ahmad Fathi
Rank: #39693
73Views
4Comments
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
on 12th Jul
Copy link to comment
Rahul Sahu
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

1
0
on 12th Jul
Copy link to comment

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
on 12th Jul
Copy link to comment
Rahul Sahu
Rank: #89

welcome Ahmad.

cheers..


1
0
on 13th Jul
Copy link to comment
Company
Corporate Site
Contacts
Cookie Policy
Support
Technical Support
Community Forums
 OutSystems© All rights reserved. Custom built with (h) and (o)