How to identify whether an Excel file conforms to Excel 95 or Excel 97 specifications?

excel specifications file-format
Priyank Bolia picture Priyank Bolia · Feb 5, 2009 · Viewed 17.3k times · Source

How to identify where the Excel file use Excel 95 or Excel 97 specifications? i.e., which version of BIFF they uses.

Answer

Dirk Vollmar picture Dirk Vollmar · Apr 24, 2009

You can find the necessary information in the MICROSOFT OFFICE EXCEL 97-2007 BINARY FILE FORMAT SPECIFICATION available from Microsoft.

See page 11 for the following explanation:

BIFF       Microsoft Office Excel version
---------------------------------------------------
BIFF5      Microsoft Excel version 5.0 (XL5)
BIFF7      Microsoft Excel 95 (XL7) (also called Microsoft Excel version 7)
BIFF8      Microsoft Excel 97 (XL8), Microsoft Excel 2000 (XL9), 
           Microsoft Excel 2002 (XL10), Microsoft Office Excel 2003 (XL11), 
           Microsoft Office Excel 2007 (XL12)

You can identify the BIFF version used in an XLS file from the Beginning Of File (BOF) record present in all BIFF version 5, 7, and 8 files. In BIFF4 and earlier versions, various records (other than the BOF record) have version information specified in the high-order byte of their record numbers. This was a redundant methodology, so for versions of BIFF after BIFF4, Excel obtains the BIFF version by reading the BOF record.

The BOF record is described in detail on page 43 of the same document.

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More