xls.txt

常见的一些文件如WORD、JPG等的文件格式

Each reference in the array consists of 6 bytes arranged as follows:
      Byte Number           Byte Description
          0-1               First row in the reference
          2-3               Last row in the reference
           4                First column in the reference
           5                Last column in the reference 
FORMAT                      1Eh                         30d

Record Type: FORMAT
Description: Describes a picture format in a document.  All FORMAT records must appear
together in a BIFF file.
Record Body Length: Variable
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
           0                Length of format string
          1-on              Picture format string
FORMATCOUNT                 1Fh                         31d

Record Type: FORMATCOUNT
Description: The number of standard FORMAT records in the file.  There are 21 different
format records.
Record Body Length: 2 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-1               Number of built in format records.
COLUMN DEFAULT              20h                         32d

Record Type: COLUMN DEFAULT
Description: Specifies default cell attributes for cells in a particular column.  The
default value is overriden for individual cells by a subsequent explicit definition.
Record Body Length: Variable
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-1               Column number of first column for which a 
                              default cell is being defined
          2-3               Column number of last column for which a 
                              default cell is being defined, plus 1.
          4-on              Array of cell attributes
ARRAY                       21h                         33d

Record Type: ARRAY
Description: Describes a formula entered into a range of cells as an array.  Occurs
immediately after the FORMULA record for the upper left corner of the array.
Record Body Length: variable
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               First row of the array
          2-3               Last row of the array
           4                First column of the array
           5                Last column of the array
           6                Recalculation flag
                              Array is calculated             0
                              Needs to be calculated         nonzero
           7                Length of parsed expression
          8-on              Parsed expression (array formula)
1904                        22h                         34d

Record Type: 1904
Description: Specifies date system used on this spreadsheet
Record Body Length: 2 bytes
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               Specifies date system used
                              1904 date system                 1
                              anything else                    0
EXTERNNAME                  23h                         35d

Record Type: EXTERNNAME
Description: An externally referenced name, referring to a work-sheet or macro sheet or
to a DDE topic.  All EXTERNNAME records associated with a supporting document must
directly follow its EXTERNSHEET record.
Record Body Length: Variable
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
           0                Length of the name
          1-on              The name
When EXTERNNAME references a DDE topic, Excel may append its most recent values to the
EXTERNNAME record.  If the record becomes too long to be contained in a single record,
it is split into multiple records, with CONTINUE records holding the excess.
COLWIDTH                    24h                         36d

Record Type: COLWIDTH
Description: Sets column width for a range of columns
Record Body Length: 3 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
           0                First column in the range
           1                Last column in the range
          2-3               Column width in units of 1/256th of a 
                            character
DEFAULT ROW HEIGHT          25h                         37d

Record Type: DEFAULT ROW HEIGHT
Description: Specifies the height of all rows that are not defined explicitly
Record Body Length: 2 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents  (hex)
          0-1               Default row height in units of 1/20th of a 
                            point
LEFT MARGIN                 26h                          38d

Record Type: LEFT MARGIN
Description: Specifies the left margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-7               Left margin (IEEE format, see Appendix A)
RIGHT MARGIN                27h                         39d

Record Type: RIGHT MARGIN
Description: Specifies the right margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-7               Right margin (IEEE format, see Appendix A)
TOP MARGIN                  28h                         40d

Record Type: TOP MARGIN
Description: Specifies the top margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-7               Top margin (IEEE format, see Appendix A)
BOTTOM MARGIN               29h                         41d

Record Type: BOTTOM MARGIN
Description: Specifies the bottom margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-7               Bottom margin (IEEE format, see Appendix A)
PRINT ROW HEADERS           2Ah                          42d

Record Type: PRINT ROW HEADERS
Description: Flag determines whether to include row and column headers on printout of
document
Record Body Length: 
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               Row and Column Header Print Flag
                              Do not print headers             0
                              Print headers                    1
PRINT GRIDLINES             2Bh                         43d

Record Type: PRINT GRIDLINES
Description: Flag determines whether to print gridlines on print-out of document
Record Body Length: 2
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               Gridline Print Flag
                              Do not print gridlines           0
                              Print gridlines                  1
FILEPASS                    2Fh                         47d

Record Type: FILEPASS
Description: Specifies a file password.  If this record is present, the rest of the file
is encrypted.  The file password specified here is distinct from the document password
specified by the PASSWORD record.  If present, the FILEPASS record must immediately
follow the BOF record.
Record Body Length: ?
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-on              ?
FONT                        31h                         49d

Record Type: FONT
Description: Describes an entry in the document's font table.  A document may have up to
4 different fonts, numbered 0 to 3.  Font records are written in the font table in the
order in which they are encountered in the file.
Record Body Length: variable
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (binary)
          0-1               Height of the font (in 1/20ths of a point)
          2-3               Font Attributes
                              First byte (reserved)             00000000b
                              Second byte
                                Bit 0 - bold                        1b
                                Bit 1 - italic                      1b
                                Bit 2 - underline                   1b
                                Bit 2 - strikeout                   1b
                                Bits 4-7 (reserved)               0000b
           4                Length of font name
          5-?               Font name
FONT2                    32h                         50d

Record Type: FONT2
Description:  System specific information about the font defined in the previous FONT
record.  The FONT2 record is option-al.
Record Body Length: Variable
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-on              ?
TABLE                    36h                         54d

Record Type: TABLE
Description: Describes a one-input row or column table created through the Data Table
command
Record Body Length: 12 bytes
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               First row of the table
          2-3               Last row of the table
           4                First column of the table
           5                Last column of the table
           6                Recalculation flag
                              Table is recalculated           0
                              Not recalculated              nonzero
           7                Row or column input table flag
                              Column input table              0
                              Row input table                 1
          8-9               Row of the input cell
          10-11             Column of the input cell
The area given by the first and last rows and columns does not include the outer row or
column, which contains table formulas or input values.  If the input cell is a deleted
reference, the row of the input cell, given by the bytes at offset 8 and 9, is -1.
TABLE2                    37h                         55d

Record Type: TABLE2
Description: Describes a two-input table created by the Data Table command.  It is the
same as the TABLE record, except there is no distinction between a row input table and a
column input table, there are two input cells rather than one, and either may have a
value of -1, indicating a deleted reference.
Record Body Length: 16 bytes
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               First row of the table
          2-3               Last row of the table
           4                First column of the table
           5                Last column of the table
           6                Recalculation flag
                              Table is calculated              0
                              Needs recalculation           nonzero
           7                RESERVED - must be zero            0
          8-9               Row of the row input cell
          10-11             Column of the row input cell
          12-13             Row of the column input cell
          14-15             Column of the column input cell
CONTINUE                    3Ch                         60d

Record Type: CONTINUE
Description: Continuation of FORMULA, ARRAY, or EXTERNNAME records that are too long to
fit in a single record.
Record Body Length: variable
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-on              Parsed expression
WINDOW1                    3Dh                          61d

Record Type: WINDOW1
Description: Basic window information.  Locations are relative to the upper left corner
of the Microsoft Windows desktop, and are measured in units of 1/20th of a point.
Record Body Length: 9 bytes
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
          0-1               Horizontal position of the window
          2-3               Vertical position of the window
          4-5               Width of the window
          6-7               Height of the window
           8               Hidden attribute
                             Window is not hidden             0
                             Window is hidden                 1
If you do not include a WINDOW1 record in your BIFF file, Excel will create a default
window in your document.
WINDOW2                    3Eh                         62d

Record Type: WINDOW2
Description: Advanced window information.  The WINDOW2 record is optional.  If present,
it must immediately follow the WINDOW1 record.
Record Body Length: 14 bytes
Record Body Byte Structure:
      Byte Number           Byte Description              Contents (hex)
           0                Display Formulas
                              Display values                   0
                              Display formulas                 1
           1                Display Grid
                              Do not display gridlines         0
                              Display gridlines                1
           2                Display Row and Column Headers
                              Do not display headers           0
                              Display headers
           3                Freeze window panes
                              Do not freeze panes              0
                              Freeze panes                     1
           4                Display zero values
                              Suppress display                 0
                              Display zero values              1
          5-6               Top row visible in the window
          7-8               Leftmost column visible in the window
           9                Row/column header and gridline color
                              Specified in next four bytes 0 
                              Use window's default             1
                              foreground color.
          10-13             Row/column headers and gridline color (RGB)
BACKUP                    40h                         64d

Record Type: BACKUP
Description: Specifies whether a BIFF file should be backed up
Record Body Length: 2 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-1               Backup flag
                              Do not back up              0
                              Back up                     1
PANE                        41h                         65d

Record Type: PANE
Description:  Describes the number and position of unfrozen panes in a window. Panes are
created by horizontal and vertical splits, which are measured in units of 1/20th of a
point.
Record Body Length: 9 bytes
Record Body Byte Structure:
      Byte Number           Byte Description         Contents (hex)
          0-1               Horizontal position of the split, zero if none
          2-3               Vertical position of the split, zero if none
          4-5               Top row visible in the bottom pane
          6-7               Leftmost column visible in the right pane
           8                Pane number of the active pane