How can I save a wxGrid in a "real xls" file (not a "csv" one) ?
And how can I open a "xls" file using a wxGrid ?
Is there any code about this ?
Thanks a lot
wxGrid and Excel
-
- In need of some credit
- Posts: 2
- Joined: Wed Mar 02, 2005 8:48 pm
- Location: Paris, France
wxGrid and Excel
Windows XP SP2
Dev-C++ 4.9.9.2
wxWidgets 2.4.2
Dev-C++ 4.9.9.2
wxWidgets 2.4.2
Well, I guess you'll have to find some document describing the structure of a .xls file, and then provide some parsing function that will bridge between reading the file and writing the information to your wxGrid. For the structure of xls, you could probably search it up in google or, even check if OpenOffice has some developer documents describing it.
-
- I live to help wx-kind
- Posts: 194
- Joined: Mon Aug 30, 2004 1:26 pm
- Location: PA, USA
- Contact:
-
- Earned some good credits
- Posts: 120
- Joined: Sun Aug 29, 2004 3:09 pm
- Location: Grenoble, France
- Contact:
If you are on windows, you can use wxAutomationObject with the excel (office in general) automation-interface.
In fact, the automation interface (function names) is really near the visual basic for excel.
You can found all the excel automation API on the integrate visual basic editor of excel (on xp I found it menu:tools/macro/Visual basic editor) and on the visual basic editor menu:show/object explorer (I dont know its name in english, I have the french version) and a tree with all properties and method is display.
On http://www.wxwidgets.org/manuals/2.5.4/ ... tionobject , you have little example on using automation on excel.
Good luck
In fact, the automation interface (function names) is really near the visual basic for excel.
You can found all the excel automation API on the integrate visual basic editor of excel (on xp I found it menu:tools/macro/Visual basic editor) and on the visual basic editor menu:show/object explorer (I dont know its name in english, I have the french version) and a tree with all properties and method is display.
On http://www.wxwidgets.org/manuals/2.5.4/ ... tionobject , you have little example on using automation on excel.
Good luck
-
- In need of some credit
- Posts: 2
- Joined: Wed Mar 02, 2005 8:48 pm
- Location: Paris, France
There is agood side in the web, where you can find a lot of information about the different formats.
http://www.wotsit.org
HeReSY
http://www.wotsit.org
HeReSY