Automate a button that converts an imported xls file through an upload button

Good morning people,

I need an idea. In a web application, I need the user to upload a spreadsheet in excel and my application turns the table into excel for database.

What I thought: Create an upload button for the user to fetch your file, and create an action to convert to the database. What would be the best way to automate this action?

Open for suggestions.


Thank you very much in advance.

I think that's a simple task.

Outsystems has an "Excel to Record List" action.

You can do it like this:

Put a submit button in the End of your action and in the Screen Action of the Submit you can use the "Excel to Record List" action to transform your file into a Record List ready to save in the database according to the structure defined in the Excel Action.


Try someting like this:

Hope it helps,


Cheers,


Eduardo Oliveira