Excel API for C/C++

fcrochik · wrote on 6 Jan 2011, 00:31

I see.... so the issue is not exactly with the license...

goetz · wrote on 6 Jan 2011, 00:38

The license is one of the issues. Nevermind, I have some hints I will dig into further if I ever have some spare time.

kunashir · wrote on 24 Jun 2011, 06:46

Volker, as your successes with excel?
I use libxls, but some excel's files in russian language not read correctly (I realized because of the inability to convert data from a file in UTF-16). If you have any achievements, can you tell us about them?

goetz · wrote on 24 Jun 2011, 09:04

I did not look into libxls yet, so sorry, no advice from my side.

Jupiter · wrote on 24 Jun 2011, 09:35

is there also something for word documents (*.doc or *.docx)?

mogz · wrote on 27 Jun 2011, 07:24

You could maybe take a look at "http://www.libxl.com/":http://www.libxl.com/

andre · wrote on 27 Jun 2011, 07:25

[quote author="mogz" date="1309159483"]You could maybe take a look at "http://www.libxl.com/":http://www.libxl.com/[/quote]
That lib was already mentioned on the first page of this topic.

Jupiter · wrote on 27 Jun 2011, 07:51

well in its documentation it says it works for excel files only. i need word documents. or didnt i see the word classes?

mogz · wrote on 27 Jun 2011, 07:57

oops! the post was meant for the main title. guess i'll have to take my time next time. sorry for that

uzakm · wrote on 28 Jun 2011, 08:41

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.

flight9 · wrote on 6 Apr 2012, 02:34

Does anyone try using QSqlDatabase to do the work?

goetz · wrote on 6 Apr 2012, 12:45

[quote author="flight9" date="1333679679"]Does anyone try using QSqlDatabase to do the work?[/quote]

You would need an SQL driver for that. I don't know of any one - do you do?

andre · wrote on 6 Apr 2012, 12:54

[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.

3electrons · wrote on 11 Apr 2012, 13:06

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.

3electrons · wrote on 11 Apr 2012, 13:10

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.

garfee · wrote on 18 Apr 2012, 10:02

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.

jdavet · wrote on 15 May 2012, 12:28

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

goetz · wrote on 27 May 2012, 15:39

[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.

Kyle24 · 12 Jun 2016, 05:43

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.