Excel File loading and button activity for displaying its data

Hello everybody.

Guys tell me how I can upload the Excel file and when I click on the button, display all its contents in a table or in the data warehouse.

Hi there,

Have a look at Jorge's solution in the following post please:

https://www.outsystems.com/forums/discussion/26480/import-excel-file-and-update-my-table-records/

Regards,

Nordin

Nordin Ahdi wrote:

Hi there,

Have a look at Jorge's solution in the following post please:

https://www.outsystems.com/forums/discussion/26480/import-excel-file-and-update-my-table-records/

Regards,

Nordin

This is not exactly what I need, but thanks for the answer. I need more detailed instructions or information.


Hi,

You will have to pick up one or other approach mentioned on link that Nordin has shared, yet I will try to give you more details.

I am assuming that you want your application users be able to upload an excel file and then see the content on the screen in a table records component. Below are the steps you can follow.

1. Provide an option on the screen to upload the file, easiest way is to use the OutSystems upload widget. Implement checks to validate the file.

2. Next you need to use ExcelToRecordsList component to convert excel records into list of target records.

3. Then to display records on the screen, then either you can directly bind the output of the ExcelToRecordsList to table records component or first store the ExcelToRecordsList output in database table and then use an aggregate to display records on screen.

Hope this helps!