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

[Thank You]

@JonB
Sorry I can't understand python at all

Can you send me link where there is information for printing all the data in C++

[JonB]

@Thank-You said in How can I export QTableView to Excel file (*.xlsx):

Sorry I can't understand python at all

Well that's a shame, because when I was doing Python Qt I had to adapt all examples from C++, which I managed. The important part here is really just https://doc.qt.io/qt-5/qtexttableformat.html. The example code is self-explanatory, and dead easy to convert, IMHO. Up to you what effort you want to make.

Can you send me link where there is information for printing all the data in C++

What information for "printing all the data in C++"?

[Thank You]

@JonB Ya its bad
But I don't want to learn python in any way
I don't like it at all and mainly while using QT at least for now

I mean if you know about c++ code for printing QTableView then send me link
I searched today for many hours
It would be very helpful

[JonB]

@Thank-You
Since I wrote the code I gave you myself, I'm hardly going to know about some other C++ equivalent. You don't have to know any Python to figure it. Best of luck.

[Thank You]

@JonB Can you post the way of exporting to .csv files

[JonB]

@Thank-You
No, it's in Python too.

[Thank You]

@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 there

Its so important
I am continiously searching this for whole day
Please help me

[mrjj]

@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]

@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 here

If You know how to do it then suggest me
Else suggest me to export in .csv file

[mrjj]

@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

[JonB]

@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 XLS as XSL... :)

[mrjj]

@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 :)

[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

[mrjj]

@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 :)