How to Save my TableView as an Excel File ?
-
Hi, ~Riz!
I haven't tried it yet but I it's not hard to find a bit on qt devnet.
http://qt-project.org/wiki/Handling_Microsoft_Excel_file_format
-
There is no support for excel format in Qt, but maybe in your case a .csv file would be enough? Excel opens them just fine and writing to it is as simple as iterating through the table cells and inserting semicolons between so basically a short loop.
-
[quote author="tucnak" date="1352741847"]Hi, ~Riz!
I haven't tried it yet but I it's not hard to find a bit on qt devnet.
http://qt-project.org/wiki/Handling_Microsoft_Excel_file_format[/quote]
Thanks for your link tucnak.. :-)
-
[quote author="Riz" date="1352748048"]
[quote author="tucnak" date="1352741847"]Hi, ~Riz!I haven't tried it yet but I it's not hard to find a bit on qt devnet.
http://qt-project.org/wiki/Handling_Microsoft_Excel_file_format[/quote]
Thanks for your link tucnak.. :-)[/quote]
You are welcome. So if issue solved, you should:
@
Devnet::Thread *q = Devnet::Instance()->currentThread();
q->setHeading( q->heading().prepend("[SOLVED] ") );
q->update();
@ -
[quote author="Riz" date="1352748263"]
Yeah.. That's Fine for my case.. Can u plz give me an example of it.
[/quote]
C'mon man, put some google into it ;)
But ok, here you go, example of csv file: http://en.wikipedia.org/wiki/Comma-separated_values#Example -
[quote author="Krzysztof Kawa" date="1352749847"]
[quote author="Riz" date="1352748263"]
Yeah.. That's Fine for my case.. Can u plz give me an example of it.
[/quote]
C'mon man, put some google into it ;)
But ok, here you go, example of csv file: http://en.wikipedia.org/wiki/Comma-separated_values#Example[/quote]Yes, it's common problem of our new generation. We are lazy, it's too hard for us to search a bit on devnet or to google. But I try to fight with my lazy-side :-).
-
[quote author="tucnak" date="1352750634"][quote author="Krzysztof Kawa" date="1352749847"]
[quote author="Riz" date="1352748263"]
Yeah.. That's Fine for my case.. Can u plz give me an example of it.
[/quote]
C'mon man, put some google into it ;)
But ok, here you go, example of csv file: http://en.wikipedia.org/wiki/Comma-separated_values#Example[/quote]Yes, it's common problem of our new generation. We are lazy, it's too hard for us to search a bit on devnet or to google. But I try to fight with my lazy-side :-).[/quote]
Yeah You are Right Tucnak... Even sometimes i feel lazy to Search in devnet or to google it... My Apologies for that. As Tucnak said, I 'll also wll try to fight with my lazy side... :-)
-
Just think about it next time. I lost 10s of my life copy/pasting it so you can save 5s of yours googling it :P
