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...splay=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.