How can I export QTableView to Excel file (*.xlsx)
-
@Thank-You
Still depends on how much control over the printed output you wish to exert. For example, exporting to a.csvis *much * easier, but you'll end up with just column data imported into Excel, not, say, column widths, or font bolding or whatever. Only you know how much you need.BTW, do you know that you want to export to Excel to do printing? When I wanted to print a
QTableView, although I offered an option to export to Excel I actually wrote code to just print off theQTableViewinside Qt program. By "converting" it to aQTextDocument, which gives you HTML/PDF printing without external programs. I was quite happy with that result, without resorting to Excel or actual PDF commands. But again depends on just what you wish to achieve. -
@Thank-You
No, it's in Python too.@JonB Do you know any method to export to any file (.xlsx or .csv or .pdf) or simply print
https://stackoverflow.com/questions/3147030/qtableview-printing
This link worked but
I have tableview with 30 columns
So Data break thereIts so important
I am continiously searching this for whole day
Please help meLet's make QT free or It will go forever
TRUE AND FALSE <3
-
@JonB Do you know any method to export to any file (.xlsx or .csv or .pdf) or simply print
https://stackoverflow.com/questions/3147030/qtableview-printing
This link worked but
I have tableview with 30 columns
So Data break thereIts so important
I am continiously searching this for whole day
Please help me@Thank-You
Hi
It's quite different to export to CSV versus actually printing to a pdf as with
CSV file the number of columns doesn't matter but with actual printing, you have the page limits to consider.So do you need actual printing (PDF) or is data export just fine ? ( CSV)
With CSV you will get a file which you have to print using excel or other app than can import CSV file. -
@Thank-You
Hi
It's quite different to export to CSV versus actually printing to a pdf as with
CSV file the number of columns doesn't matter but with actual printing, you have the page limits to consider.So do you need actual printing (PDF) or is data export just fine ? ( CSV)
With CSV you will get a file which you have to print using excel or other app than can import CSV file.@mrjj Ok its fine but I want to export
https://stackoverflow.com/questions/3147030/qtableview-printing
This actually worked but all the data do not fit hereIf You know how to do it then suggest me
Else suggest me to export in .csv fileLet's make QT free or It will go forever
TRUE AND FALSE <3
-
@mrjj Ok its fine but I want to export
https://stackoverflow.com/questions/3147030/qtableview-printing
This actually worked but all the data do not fit hereIf You know how to do it then suggest me
Else suggest me to export in .csv file@Thank-You
Hi
For actual printing, your only option is to reduce the font size to try to make it fit to paper.
Maybe also set it to landscape mode. But it sounds like it really cant fit if you have 30.
Page wrapping on width is hard with a table. (IMHO)For export to CSV. you can use
https://github.com/VSRonin/QtModelUtilities
it has a nice exporter
https://vsronin.github.io/QtModelUtilities/class_csv_model_serialiser.html -
@Thank-You
Hi
For actual printing, your only option is to reduce the font size to try to make it fit to paper.
Maybe also set it to landscape mode. But it sounds like it really cant fit if you have 30.
Page wrapping on width is hard with a table. (IMHO)For export to CSV. you can use
https://github.com/VSRonin/QtModelUtilities
it has a nice exporter
https://vsronin.github.io/QtModelUtilities/class_csv_model_serialiser.html -
@mrjj said in How can I export QTableView to Excel file (*.xlsx):
For export to CVS. you can use
CVS is a US pharmacy chain, don't think they accept any exported files... ;-)
Same thing as I seem to mistype Excel
XLSasXSL... :) -
@JonB
hehe thx
Yes I always swap those letters for some odd reason.
And to make it more ironic, Excel uses tabs for its COMMA separated files pr default :)@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
Be aware of the Qt Code of Conduct, when posting : https://forum.qt.io/topic/113070/qt-code-of-conduct
Q: What's that?
A: It's blue light.
Q: What does it do?
A: It turns blue. -
@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
@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 :)
