Want to read data from excel files and write them into PostgreSQL

[morphism]

Dear everyone

I am pretty new to QML but really love it because QML offers nice 3D rendering together

I am developing an app like below

1. Read relational data from MS excel files (or MS csv files)
2. Write them into some tables in PostgreSQL 15.2

and vice versa ( PostgreSQL 15.2 --> MS excel files)

But at this moment
I am not sure whether QML has such features ( MS excel file support, PostgreSQL 15.2 support)

So could you please help me with this issue?

Thank you and have a great weekend

[JonB]

@morphism
QML won't have support, but Qt code supports PostgreSQL for its QSql... classes (can't say anything about version 15.2). There is limited support for Excel files (e.g. see https://wiki.qt.io/Handling_Microsoft_Excel_file_format, https://github.com/QtExcel/QXlsx) and maybe https://github.com/iamantony/qtcsv for CSV.

[morphism]

@JonB
Dear JonB

Oh, thank you very much for your valuable answers and kindness

You saved my time a lot !

I learned important facts from you, so I will focus on Qt itself now

Also thank you for those links you suggest

Have a nice Sunday and see you again, Jon

Take care