PDA

View Full Version : Manipulating excel files in Qt?



icttrack
24th July 2010, 05:49
i am having an assignment which requires me to manipulate excel file in Qt. The program must be platform-independent so i am not allowed to use COM, OLE or something proprietary in Windows. Can anyone provide me with an opensource library that can enable me to do this task. I have searched google for a while but no luck.

ChrisW67
24th July 2010, 07:20
Given that Excel is not cross-platform and its file formats are not openly documented this seems like a strange assignment.

You could look into the source of OpenOffice to see how they handle it.

icttrack
24th July 2010, 11:44
thanks for your reply. I think i might find the solution. Here is the link : http://www.codeproject.com/KB/office/ExcelFormat.aspx?display=PrintAll

Strix Code
24th July 2010, 11:44
There is a multiplatform (commercial) C/C++ library for reading/writing Excel files called LibXL.
If you can't use that then there is an Java library called Apache POI. You can create a helper Java app using that library and communicate with it from your Qt application.

Edit: @icttrack: You have replied simultaneously with me and now I see that ExcelFormat Library seems to be the best choice indeed.