Skip to Content (Press Enter)
UserImage.jpg
NIKOLLAS RONALD DE SANTANA
158Views
6Comments
Solved
Upload Excel File with widget Upload and insert into database
Question
Aggregate
Beginner
Database
File
Import/Export Data

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
0
0
18 Feb 2022
Copy Link
UserImage.jpg
NIKOLLAS RONALD DE SANTANA

Thanks! That's worked

0
0
18 Feb 2022
Copy Link
UserImage.jpg
NIKOLLAS RONALD DE SANTANA

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

0
0
18 Feb 2022
Copy Link
2021-06-09 13-39-18
Agno Silveira
 
MVP

Hello Nikollas,

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

I hope it helps.

UploadExcel.oml
0
0
18 Feb 2022
Copy Link
2021-06-09 13-39-18
Agno Silveira
 
MVP

Excel file to upload.

UploadExample.xlsx
0
0
18 Feb 2022
Copy Link
UserImage.jpg
NIKOLLAS RONALD DE SANTANA

Thanks! That's worked

0
0
18 Feb 2022
Copy Link
UserImage.jpg
NIKOLLAS RONALD DE SANTANA

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

0
0
18 Feb 2022
Copy Link
2020-09-01 10-42-42
Stefano Valente

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.


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