Excel Format documentation

  • Thread starter Thread starter Oleg Fedtchenko
  • Start date Start date
O

Oleg Fedtchenko

I cannot find any documentation for Excel file format to
develop an engine for my software to output Excel files.

Who can advise on this? Thank you
 
I cannot find any documentation for Excel file format to
develop an engine for my software to output Excel files.

Who can advise on this? Thank you
Click to expand...

Both OpenOffice and the Gnome Project's gnumeric read and write XLS files, and
both are open source. There may be enough there to figure out the file format.
 
I cannot find any documentation for Excel file format to
develop an engine for my software to output Excel files.

Who can advise on this? Thank you
Click to expand...

You'll find several descriptions of Excel's BIFF format at www.wotsit.org

Regards,
Vic Eldridge
 
I cannot find any documentation for Excel file format to
develop an engine for my software to output Excel files.

Who can advise on this? Thank you
Click to expand...

There are a couple of options.

1) Find a copy of the 'Excel 97 Developers kit' it had some docs
2) Look at the online docs for openoffice
3) Look at the source code for gnumeric (gnumeric/plugins/excel)
4) Have a look at the hssf project that is part of apache
5) Use perl:excelwrite

However, none of these answer the real question. Why do you need to
generate the xls directly ? If you are willing to take a slightly
more indirect approach I'd suggest generating gnumeric formated xml,
then using ssconvert to map that to xls. The xml is much easier to
read, and you'd be able to spring board off of the gnumeric xls
exporter and its maintenance and bugfixing.

Good Luck
Jody (Gnumeric maintainer)
 
Back
Top