Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Deciphering the Excel 2000 file format (Read 1922 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Deciphering the Excel 2000 file format
06.02.06 at 13:12:02
 
I started today trying to decipher the Excel workbook file. Through litXLS I have already implemented code to write a xls file. However this file can only contain 1 worksheet. A complete workbook is far more complex.
Back to top
 
« Last Edit: 02.04.06 at 21:34:08 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Deciphering the Excel 2000 file format
Reply #1 - 08.02.06 at 09:19:32
 
I managed today to find all records in an empty xls file with 3 sheets. Now I have to work out what all fields mean and how to write a new xls from scratch without the help from Excel... This is just a first step I realise. More to follow later.
Back to top
 
« Last Edit: 02.04.06 at 21:34:30 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: week 6 - Excel file format
Reply #2 - 12.02.06 at 22:42:26
 
Have been playing with the Excel file format all day. I managed to read a blank, 3 sheet, xls file and identify all records in it. I also managed to write the records back into a file that can be read in ok by Excel.
The basis for deciphering the file format is therefore achieved. Ahead lies the much more complex task of writing a file from scratch. I need to continue first to parse all records in the blank 3 sheet cls file as that gives me a minimal workbook to start with. That will take a while to complete.
Back to top
 
« Last Edit: 02.04.06 at 21:35:07 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1