how to export my sql table(Qtableview) to a text file or .ods file

**prasad1001** · 28th February 2014, 10:09

Hello all,
First of all sorry for my english....
I was created a sqlite database and a table and it is displaying on the Qtableview of my mainwindow...Now i want to save the table to a text file or a .ods (or Excel file).
Anybody can please give some instructions to this....

Thanks in advance...

**folibis** · 28th February 2014, 11:48

you can save it to .csv, both Excel and OO can read it.

**adutzu89** · 28th February 2014, 12:19

Get the content from database into a QString and after that use QTextStream and QFile to make a .csv file with the content inside QString. Simple as that.
.csv(comma separated values) can be opened by any spreadsheet(Ms Excel,LibreOffice,OpenOffice etc) application and by any text editor.