Upload Excel File with widget Upload and insert into database

Hi, i am from Brazil! I have tried upload an excel file and  insert the data of cells in my database but i have no ideia how to use the uploaded excel file for insert into my database.

Captura de Tela (4).png

Thanks! That's worked

Do you know how to make this with a Json? I have to upload a json because de API is not working with outsystems

mvp_badge
MVP

Hello Nikollas,

I have an upload example to save and edit records, attached.

I hope it helps.

UploadExcel.oml

mvp_badge
MVP

Excel file to upload.

UploadExample.xlsx

Thanks! That's worked

Do you know how to make this with a Json? I have to upload a json because de API is not working with outsystems

IF you want to be a good developer, you should be lazy :)


you can see how this import from excel works by creating a bootstrap function:

create an excel with a headerrow and some dummy values.

Just go to Entity and select:


It will not only create the entity, but also a timer with a bootstrap function.


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