Re: How to build a program that can read the content of a very simple MS Excel file?



On Thu, Jun 14, 2007 at 11:40:32AM +0700, Huge Mountain wrote:
Thank all you for your help!

I have another question:
I'm trying to get the binary format of MS Excel file with this book,
excelfileformat.pdf from http://sc.openoffice.org/excelfileformat.pdf
In part 5.4, page 81, we have:
Structure of the Page Settings Block in the Worksheet Substream:
??? HORIZONTALPAGEBREAKS ???6.54
??? VERTICALPAGEBREAKS ???6.107
??? HEADER ???6.51
??? FOOTER ???6.44
??? HCENTER ???6.50 (BIFF3-BIFF8 only)
??? VCENTER ???6.106 (BIFF3-BIFF8 only)
??? LEFTMARGIN ???6.62
??? RIGHTMARGIN ???6.81
??? TOPMARGIN ???6.103
??? BOTTOMMARGIN ???6.11
??? PLS
??? SETUP ???6.89 (BIFF4-BIFF8 only)
??? BITMAP ???6.6 (BIFF8 only)
Every record is described clearly, except PLS which isn't mentioned in this
document. I don't know if it's a record or something else. I have been seen
the binary format of a MS Excel file (created by MS Excel 2000). If I
consider PLS as a record, with this excel file  I have PLS's ID is 77 (equal
4D in hex) and size of following data is 1454 byte.
The excelfileformat document doesn't discribe PLS's format. Could you help
me to know this "record"?

The the content of a PLS record is yet another instance of a record
within a record.  It is a binary blob of printer description data.
The wine (windows emulator) groups may know more.

PS
    You can use libgsf/tests/test-msole1 in conjunction with the
    file gnumeric/plugins/biff-types.h to dump the BIFF content of
    files as binary blobs.  OOo has an xldumper program that goes
    further, but it is only enabled in debug builds.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]