Is it possible to organize communication between QT, mySQL and Excel?

Question

SQL

Hello. There is an organization that keeps a daily record of "arrivals and departures of maritime transport." All accounting is kept in 3 excel documents. But it is not convenient to fill it, we decided to make an interface for filling. Here, once again, a stupor arose. there is an idea to link QT mySQL and Excel. That the data was stored both in Excel and in a DB. Is there an easier solution? Or use something instead of qt?

Answer 1

Qt and MySQL work great and are very fast. A little hint: in addition to the driver DLL, which must be thrown into the plugins\sqldrivers subdirectory, you must put the MySQL or MariaDB DLL in the WORKING directory of the program (depending on the Qt build).
It's more complicated with Excel, and you have to look for any Excel library available in C++.
Of the open ones - XLNT (cross-platform) and QtXlsx (tied to the Qt class system).
We partially use LibXL (paid, slow, huge memory consumption, but QtXlsx is even worse, as far as I checked), partially our bike (minimum functionality, optimized for huge XLSX - up to the fact that Excel takes a large table in 10 seconds, and we for three, and LibreOffice generally thinks about it for minutes).
But this is actually a question: what is there for Excel in C++. Maybe raw XLNT was brought to mind. Maybe you do not have huge tables, and what you have is enough for you ...
UPD. There are different builds of the MySQL DLL, so you have to experiment to make it work not only on a development machine, but also on a potential user.

Answer 2

what does google say?
take C# - there will definitely be more options
ps By and large, QT + MySql should fit without problems, there should be grids in QT, and I need to get rid of Excel. no matter what interface+bd you rely on. spreadsheets are good for quick sketches. but when you try to keep records, features come out .. accounting ..

Answer 3

From the filling interface, you can save to csv and open it in excel.
It is better to refuse excel altogether, it will be much more convenient and safe to use the database.

Answer 4

Wrong IC architecture. Throw out Excel, use a database (MySQL / SQLite, etc). Interface - any to your taste (even web app, though the same Qt). PL for implementation - a lot of options.

Answer 5

All accounting is kept in 3 excel documents.

If it's more convenient, write a macro in Excel.