ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Format documentation (https://www.excelbanter.com/excel-programming/288503-excel-format-documentation.html)

Oleg Fedtchenko

Excel Format documentation
 
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

Jim Rech

Excel Format documentation
 
MS no longer publicly documents Excel's binary file format. As this article
mentions you can request the documentation from them:

http://support.microsoft.com?kbid=239653

--
Jim Rech
Excel MVP



Harlan Grove[_5_]

Excel Format documentation
 
"Oleg Fedtchenko" wrote...
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


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.

--
To top-post is human, to bottom-post and snip is sublime.

Vic Eldridge

Excel Format documentation
 
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


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

Regards,
Vic Eldridge

Jody Goldberg

Excel Format documentation
 
On 2004-01-20, Oleg Fedtchenko wrote:
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


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)


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com