My approach to export QTableView data to a Microsoft Excel file

[amit_ais]

In this application we need to create a new database that is directly export into excel file, there is no storage for db file...it is good. but please tell me , how to export existing database file into excel file?

Thanks

In this application we need to create a new database that is directly export into excel file, there is no storage for db file...it is good. but please tell me , how to export existing database file into excel file?

Thanks

[thietnguu]

Hi All !
i create success a project export to excel on window. but when i work on ubuntu not success. Help me please!

[d_stranz]

How does the export work? Does it use Qt's ActiveX interface to MS Excel COM? That does not work on any platform except Windows.

[thietnguu]

i created a project as example " TestTableView" of Venomj. it runs normal on Windows.but not runs on Ubuntu

[anda_skoa]

i created a project as example " TestTableView" of Venomj. it runs normal on Windows.but not runs on Ubuntu

That example uses ActiveX to remote control an Excel instance. Which, as d_stranz said, obviously only works when there is ActiveX and Excel on the system.
Microsoft has not released either for Linux yet.

Cheers,
_

[thietnguu]

on ubuntu do you know how export to excell?

[anda_skoa]

Depends on what you need.

If you just have a table of values you could write a simple CSV file.
Excel can import these.

Cheers,
_

[d_stranz]

Take a look at libXL. There are versions for C, C++ and other languages, and is portable to Windows, linux, Mac, and iOS. It does not require Excel, but can produce xls, xlsx, and xlsm formats that can be opened as workbooks in Excel.

This a commercial library (it isn't free). You can download a demo version that has limited capability if you want to try it out.

There might be open-source libraries available, but I haven't looked.

[wodus18]

I'm sorry, but the compressed file attached to the body is empty. Can you upload the full contents of the compressed file or source code again?

[d_stranz]

This is a 10 year old post, and the last time the OP posted anything to this forum was also 10 years ago. If the zip file is no longer accessible, then it is very unlikely it will be re-posted. The OP is long gone from this forum.

Try searching using Google for Excel export libraries. You can also simply write the table out as a CSV file, which Excel or any other spreadsheet program can import.