Excel API for C/C++

goetz

From http://www.koffice.org/contribute/:

bq. KOffice is released under the LGPL v2+ (and GPL v2+ for some parts).

fcrochik

[quote author="Volker" date="1294273445"]From http://www.koffice.org/contribute/:

bq. KOffice is released under the LGPL v2+ (and GPL v2+ for some parts).[/quote]

Why was that a problem then? Can't get much more flexible than that (unles you are looking for the one part that is only GPL and you want to release a closed source app).

EDIT: before I get screamed at: warning: I don't have any idea of the details about "v2+"

goetz

I'd have to extract the parts I need, remove the KDE stuff (not available on Windows and Mac) and publish it as a new LGPL project. We do not have the time for that at the moment and it's not on top of the want-have list of the customer.

fcrochik

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

goetz

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

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

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

Jupiter

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

mogz

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

andre

[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

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

mogz

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

uzakm

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

Does anyone try using QSqlDatabase to do the work?

goetz

[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

[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

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

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

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

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