Excel API for C/C++

goetz

You did read of that "platform independent" thingy, didn't you? :) To be able to work on a Mac I cannot use the Microsoft tools. And of course that tool exists, it's called Excel :)

xsacha

I think it's a downloadable tool for people with old versions of Excel actually. Standalone. But yes, it was a Windows app.

You have Excel on "Mac":http://www.ehow.co.uk/how_6316841_convert-xls-xlsx-mac.html too :P

There may be a Mac app for this. Or you could try wine (or similar).

Probably make life much easier.

goetz

Come on... you cannot force your commercial customers to install wine just to convert some crappy xls files :-)

Everthing other than a lib I can incorporate to my app is not acceptable; it's more pleasent for the user if we upload the files to the business logic server then.

xsacha

Alright, I guess since it is for paying customers it is best to treat them nice.

Good luck with your Excel API. I'm sure someone has written something like it for Qt somewhere. You checked Qt-Apps already and similar sites?

This can search Excel files: http://qt-apps.org/content/show.php/recoll?content=66138
But might not have the full API.

goetz

I've searched around with google, got some things that might be interesting, but nothing with using Qt in the first search results. It's not on a very high priority at the moment, so no need to worry. I thought it's worth a try in this forum - if you don't ask, you won't get an answer...

Yash

There are 2 C++ libaries to create excel.
One is free xlslib : http://xlslib.sourceforge.net/
Other is commercial libXL : http://www.libxl.com/

Sorry for late response and I don't know whether you need this or not. But for others I share...

goetz

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

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

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

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

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

KOffice falls out due to license issues - unfortunately.

fcrochik

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

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

goetz

Thanks - corrected * 2 :-)

fcrochik

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

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.