Excel API for C/C++

goetz · wrote on 28 Dec 2010, 13:02

Thanks for the links. libxl I will have a look into. xlslib unfortunately cannot read XLS files. This is the crucial part. Writing the files could be quite easily approached with the new XML based format (thats seems not too complicated as long as there are no formulas or cross references, which we do not need).

qtrahul · wrote on 28 Dec 2010, 14:10

Another available option is to attempt to extract the code from an open source excel reading competitor.

Open Office - http://www.openoffice.org/ - is likely to be used,

Gnumeric is probably a better option.
Excel code is here - http://git.gnome.org/browse/gnumeric/tree/plugins/excel

Yash · wrote on 29 Dec 2010, 04:42

Libxls
libxls is a C library which can read Excel (xls) files. It has been tested on Linux x86 and Cygwin but may work on any little-endian system. ...
"libxls.sourceforge.net":http://libxls.sourceforge.net

[EDIT: clickable link, Volker]

goetz · wrote on 29 Dec 2010, 13:31

Thanks for the link Yash, it looks promising. It could be a good start and maybe I find some time to make a Qt version.

Panke · wrote on 5 Jan 2011, 22:45

What's about KOffice? As far as I know they use MS -> OOo -> KOffice, but they might have a cuter API to the OOo routines since they are Qt-based.

goetz · wrote on 5 Jan 2011, 23:16

KOffice falls out due to license issues - unfortunately.

fcrochik · wrote on 5 Jan 2011, 23:53

[quote author="Yash" date="1293597766"]Libxls
[EDIT: clickable link, Volker][/quote]
Not yet....

"libxls.sourceforge.net":http://libxls.sourceforge.net

goetz · wrote on 5 Jan 2011, 23:55

Thanks - corrected * 2 :-)

fcrochik · wrote on 6 Jan 2011, 00:00

Has anybody figured out what kind of license is? GPL, LGPL, ... ?

I would like to include all the "open source" tools/libraries we talk about into wikis so when needed one can find them in one place.

EDIT: What are the KOffice license issues?

goetz · wrote on 6 Jan 2011, 00:24

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

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

fcrochik · wrote on 6 Jan 2011, 00:28

[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 · wrote on 6 Jan 2011, 00:30

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 · 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?