-- 
http://www.superlinksoftware.com
http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound
Document 
                            format to java
http://developer.java.sun.com/developer/bugParade/bugs/4487555.html 
                        - fix java generics!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh
--- Begin Message ---
Hello everybody,

     Checking with an hex editor several XL sample files, I have found that  record 
BOF, BIFF8, which is used by XL 97,2000 & XP, contains the following data (little 
endian):
        09 08          Identifier
        10 00          Size of record (16 bytes)
        00 06          version
        05 00          workbook globals
        XX XX          build identifier
        XX XX          build year
        XX XX XX XX    file history flags
    *** 06 01 00 00    lowest excel version that can read all records in               
            this file
     In the last field is encoded the version of Excel able to open the document 
without problems. If this field is
             06 01 00 00
then the file can be opened by Excel 8.0(Excel 97). If it contains
             06 02 00 00
then the file needs Excel 9.0 (Excel 2000). I haven't found the value for Excel 10.0 
(XP), but as soon as I found it, I will inform you.
    If the file is Excel 95, the it's BIFF 7, and the format for record BOF is 
slightly different, as stated by OpenOffice document.
    Thanks a lot by your help guys!

Eugenio Vargas
-- 




__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

--- End Message ---

Reply via email to