Generating Excel Reports in Binary Format
April 26th, 2010
Some years ago I wrote a .NET Class that used the Microsoft Office Interop Services (Microsoft.Office.Interop.Excel). While I wrote it nearly complete to the exact specification I found it was never quite fast enough since a) it was using COM and b) I had to deal with the .NET wrappers for that unmanaged code. Knowing I had to produce the report in binary for optimal performance I pretty much gave up on ever discovering the format of the file… until today, while researching SQL Server Reporting Services when I came across these links:
“OpenOffice.org’s documentation of the Microsoft Excel File Format”
“Microsoft Office Excel 97 - 2007 Binary File Format Specification (*.xls 97-2007 format)”
Happy coding.
No related posts.
