Excel API for C/C++
-
Hi,
a lot of development has been done during the last year on the Calligra Suite filters. Calligra Suite is the fork of KOffice. You can use the koconverter to do batch conversions to ODF. However the excel filter does not follow the koconverter approach at moment. Please discuss at the #calligra channel at
freenode.Consider that any of the binary files in {.doc, .ppt, .xls} use the Compound File Binary File Format.
On top of it any graphics are stored in containers described by the MS-ODRAW spec. You can reuse libmso from Calligra Suite to parse and convert MS-ODRAW content to ODF. libmso makes use of msoscheme (http://gitorious.org/msoscheme) to parse the MS-ODRAW content. Also MS-PPT containers are parsed by msoscheme.Office Open XML support has been also improved a lot. Use the #calligra channel to discuss the details.
-
[quote author="flight9" date="1333679679"]Does anyone try using QSqlDatabase to do the work?[/quote]
What are you refering to now exactly? The original question (Excel), or something else?Because for Excel, you can actually use the QODBC drivers if you want.
-
You migt to try use OpenDocument writer supported by Qt and than convert it to Excel file with OpenOffice from command line (bacground process). Open/LibreOffice is widley present on main platforms ... unless it is mobile layer.
I have not used OpenDocument but I have sucesfully converted many OO files to Excel.
This method was not very fast - maybe now it will be ok .. but results were good. At least there is not much work to be done to test it.There is lot of resources how to do it in many ways using O/LO by use of extra macros or python but good statring point is soffice --help. There is --convert command that should work for this task.
-
I have just find it and checked:
@soffice --invisible -convert-to xls filename.xlsm -> filename.xls
soffice --invisible -convert-to xls test.ods -> test.xls
@Works like a charm ... I do not have any complicated files but it take about 1s to convert simple one page document.
-
Hi Volker,
Have you figure out the problem to Execl API for QT/C/C++?How did/will you to get it done? I met the same problem with you. It had
trappedd me for days . I'm looking for your sharing or tips.
Of course, if someone have any idea or process, sharing or tips is apreciated. -
FYI, I started a wiki page based on info from this thread here:
http://qt-project.org/wiki/Handling_Microsoft_Excel_(file_format)Please help to expand it...
-
[quote author="jdavet" date="1337084927"]FYI, I started a wiki page based on info from this thread here:
http://qt-project.org/wiki/Handling_Microsoft_Excel_(file_format)Please help to expand it...[/quote]
Thank's a lot! That summary of the current state is really helpful.
-
It appears that the link should be http://wiki.qt.io/Handling_microsoft_excel_file_format
Scroll down a bit and there is a list of c++ Excel libraries.