I have QTableView named table I want to export data in that table to filename say "c:\t.xlsx" How can I do it I did see many blogs and question on the same topic but it didn't work. https://forum.qt.io/topic/70027/export-table-view-to-xls-file https://forum.qt.io/topic/24877/how-can-i-export-to-excel-from-qt-code

Hi First of all , it must it be xlsx ? a text CSV file is not enough? (excel can read that and it super easy to generate) If you must write that format, i would use something like https://github.com/QtExcel/Qlibxlsxwriter

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How can I export QTableView to Excel file (*.xlsx)

Unsolved General and Desktop

21 Posts 4 Posters 8.2k Views 2 Watching

J J.Hilk

@mrjj I believe this is due to internalizations, as commas are used (in some regions) as decimal point where as you have a hard time typing a tab in excel in the first place :D
M Offline
M Offline
mrjj
Lifetime Qt Champion
wrote on last edited by

#21

@J-Hilk
hehe yes im pretty sure it has a very valid reason and function and was more aiming
at the ironic part, that format didn't really follow the name :)
1 Reply Last reply

1