Import to database from excel file

saltcorn / saltcorn

Free and open source no-code application builder

https://saltcorn.com/

MIT License

1.67k stars 290 forks source link

Import to database from excel file #1782

Open SebaBecks opened 1 year ago

SebaBecks commented 1 year ago

is it possible to create a view with the ability to upload a file in EXCEL format and add data to the database?

pyhedgehog commented 1 year ago

If you need to this once, you can in Excel (or Libre Calc, or using xlsx2csv, ...) convert it to CSV and import. As soon as this functionality is targetted to developer it seems enough. But if you want your application to have such (import data from excel files) functionality, you can write (or find 😊) plugin. Seems that there are a lot of libraries for this (excel, xls), but I've not checked any of them, sorry.