excel.txt

VB 不需要安装 EXECEL 直接操作 XLS 文档 的类

  11      1   RESERVED - must be zero
  12  rwInpRw  2  row of the row input cell
  14  colInpRw 2  column of the row input cell
  16  rwInpCol 2  row of the column input cell
  18  colInpCol   2   column of the column input cell

  Description
   A TABLE2 record describes a two-input table created
   through the Data Table command.

   This record is the same as the TABLE record, with the
   following exceptions:
      - There is no fRw field.  The byte is unused.
      - There are two input cells, a row input cell
        and a column input cell.
      - Either input cell, or both input cells, may
        have a row of -1 to indicate that the
        corresponding input cell is a deleted
        reference, i.e. displays as #REF!.

PROTECT record - worksheet protection (type = 18)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   fLock    2  =1 if the document is protected
          =0 if the document is not
             protected

  Description
   The PROTECT record specifies whether or not an Excel
   document has been protected through the Options Protect
   Document command.

   Note that this record specifies a document password, as
   opposed to the FILEPASS record, which specifies a file
   password.

WINDOW PROTECT record - window protection (type = 25)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   fLockWn  2  =1 if the windows of the document
             are protected
          =0 otherwise

  Description
   The WINDOW PROTECT record specifies whether or not the
   document's windows are protected, as specified in the Protect
   Document command.

PASSWORD record - worksheet password (type = 19)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   wPassword   2   encrypted password for a
          protected document

  Description
   The PASSWORD record contains the encrypted password for
   a document protected through the Options Protect Document
   command.

NOTE record - notes (type = 28)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row of the note
  6   col     2   column of the note
  8   cch     2   length of the note
  10  rgch    var  the note

  Description
   The NOTE record specifies a note associated with a cell. The
   cell is given by the rw and col fields.  cch is the length of
   the note; rgch contains the text of the note.

   Notes longer than 2048 characters must be spread across
   multiple NOTE records, each one containing at most 2048
   characters.  The first NOTE record contains the following
   fields:

  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row of the note
  6   col     2   column of the note
  8   cch     2   total length of the note (>2048)
  10  rgch    2048 the first 2048 characters of the note

   Each subsequent NOTE record for the note contains the
   following fields:

  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  =-1 always
  6       2   RESERVED - must be zero
  8   cch     2   length of this section of the note
          (<=2048)
  10  rgch    var  section of the note

WINDOW1 record - basic window information (type = 61)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   x    2  horizontal position of the
          window
  6   y    2  vertical position of the window
  8   dx   2  width of the window
  10  dy   2  height of the window
  12  fHidden  1  =1 if the window is hidden
          =0 otherwise

  Description
   The WINDOW1 record provides basic information about an
   Excel window.  The x and y fields give the location of the
   window in units of 1/20 of a point, relative to the upper
   left corner of the desktop. dx and dy give the window size,
   also in units of 1/20 of a point.  fHidden is used to specify
   a hidden window.

   If you are creating a BIFF file, you can omit the WINDOW1
   record, and Excel will create a default window into your
   document.

WINDOW2 record - advanced window information (type = 62)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   fDspFmla 1  =1 if the window should display
             formulas
          =0 if the window should display
             values
  5   fDspGrid 1  =1 if the window should display
             gridlines
          =0 otherwise
  6   fDspRwCol   1   =1 if the window should display
             row and column headers
          =0 otherwise
  7   fFrozen  1  =1 if the panes in the window
             should be frozen
          =0 otherwise
  8   fDspZeros   1   =1 if the window should display
             zero values
          =0 if the window should suppress
             display of zero values
  9   rwTop    2  top row visible in the window
  11  colLeft  2  leftmost column visible in the
          window
  13  fDefaultHdr  1  =1 if the row/column headers and
             gridlines should be drawn in
             the default foreground color
          =0 otherwise
  14  rgbHdr   4  row/column headers and gridline
          color

  Description
   The WINDOW2 record contains a fuller description of an Excel
   window.  This record is optional.  If it appears, it must
   directly follow the WINDOW1 record for the window it describes.

   The fDspFmla, fDspGrid, fDspRwCol, and fDspZeros fields are
   window properties as set in the Options Display command.
   fFrozen is as set through the Options Freeze/Unfreeze Panes
   commands.

   fDefaultHdr is 1 if the window's row and column headers and
   gridlines should be drawn in the window's default foreground
   color.  If this field is 0, then the RGB color in rgbHdr is
   used instead.

PANE Record - window split information (type = 65)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   x    2  horizontal position of the split,
          or zero if none
  6   y    2  vertical position of the split,
          or zero if none
  8   rwTop    2  top row visible in the bottom pane
  10  colLeft  2  leftmost column visible in the
          right pane
  12  pnnAct   1  pane number of the active pane

  Description
   The PANE record describes the number and position of panes in
   a window.  The x and y fields give the position of the
   vertical and horizontal splits, respectively, in units of
   1/20 of a point. Either of these fields may be zero,
   indicating that the window is not split in the corresponding
   direction.

   For a window with a horizontal split, rwTop is the topmost
   row visible in the bottom pane or panes.  For a window with a
   vertical split, colLeft gives the leftmost column visible in
   the right pane or panes.

   The pnnAct field tells which pane is the active pane.  It
   contains one of the following values:
      0   Bottom right
      1   Top right
      2   Bottom left
      3   Top left

   If the document window associated with a pane has frozen
   panes, as specified in the WINDOW2 record, then x and y have
   special meaning.  If there is a vertical split, then x
   contains the number of columns visible in the top pane. If
   there is a horizontal split, then y contains the number of
   rows visible in the left pane.  Both types of splits can be
   present in a window, as in unfrozen panes.

SELECTION record - selection within a pane (type = 29)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   pnn     1   pane number
  5   rwAct    2  row number of the active cell
  7   colAct   2  column number of the active cell
  9   irefAct  2  reference number of the active cell
  11  cref    2   number of references in the
          selection
  13  rgref    var array of references

  Description
   The SELECTION record specifies which cells are selected in a
   pane of a split window. This record may also be used to
   specify selected cells in a window which does not have any
   splits.

   The pnn field tells which pane we are describing.  It
   contains one of the following values:
      0   Bottom right
      1   Top right
      2   Bottom left
      3   Top left
   For a window which has no splits, use pnn = 3.

   rwAct and colAct specify which cell in the selection is
   the active cell.

   The selection itself consists of rgref, a variable length
   array of references.  The number of references in the record
   is given by the cref field.  Each reference is six bytes long
   and contains the following fields:

  Offset  Name    Size Contents
  ------  ----    ---- --------
  0   rwFirst  2  first row in the reference
  2   rwLast   2  last row in the reference
  4   colFirst 1  first column in the reference
  5   colLast  1  last column in the reference

   irefAct is a zero-based index into the array of references,
   specifying which reference contains the active cell.

   If a selection is so large that it won't fit in the maximum
   size BIFF record, 2084 bytes, then it is broken down into
   multiple consecutive SELECTION records.  Each record contains
   a portion of the larger selection.  Only the cref and rgref
   fields vary in the multiple records; the pnn, rwAct, colAct,
   and irefAct fields are the same over all records in the
   group.  On each record, the cref field contains the number of
   references found on that record alone.

EOF record - end of file (type = 10)
  Description
   The EOF record must be the last record in the file.
   It has no data associated with it.

Cell Attributes
---------------
  This section describes the cell attribute field found in the ROW,
  BLANK, INTEGER, NUMBER, LABEL, BOOLERR, FORMULA, and COLUMN DEFAULT
  records. The field is three bytes long and consists of bit fields:

  Offset  Bits Mask   Name    Contents
  ------  ---- ----   ----    --------
  0   7   0x80 fHidden    =1 if the cell is hidden
   6  0x40 fLocked    =1 if the cell is locked
   5-0        RESERVED - must be zeros
  1   7-6  0xC0   ifnt    font number
   5-0 0x3F   ifmt    the cell's format code
  2   7   0x80 fShade     =1 if the cell is shaded
   6  0x40 fBottom    =1 if the cell has a
              bottom border
   5  0x20 fTop    =1 if the cell has a
              top border
   4  0x10 fRight     =1 if the cell has a
              right border
   3  0x08 fLeft   =1 if the cell has a
              left border
   2-0 0x07   alc     the cell's alignment code

  The ifnt field is a zero-based index into the document's table of
  fonts. The ifmt field is a zero-based index into the document's table
  of picture formats.  See the FONT and FORMAT records for details.

  The alc field has one of the following values:
   0  General
   1  Left
   2  Center
   3  Right
   4  Fill
   7  (Multiplan only) Default alignment

Order of Records
----------------
  Here is the order in which records are written in a BIFF file:
   BOF
   FILEPASS
   INDEX
   CALCCOUNT
   CALCMODE
   PRECISION
   REFMODE
   DELTA
   ITERATION
   1904
   BACKUP
   PRINT ROW HEADERS
   PRINT GRIDLINES
   HORIZONTAL PAGE BREAKS
   VERTICAL PAGE BREAKS
   DEFAULT ROW HEIGHT
   FONT
   FONT2
   HEADER
   FOOTER
   LEFT MARGIN
   RIGHT MARGIN
   TOP MARGIN
   BOTTOM MARGIN
   COLWIDTH
   EXTERNCOUNT
   EXTERNSHEET
   EXTERNNAME
   FORMAT
   NAME
   DIMENSIONS
   COLUMN DEFAULT
   Cell table
      ROW, BLANK, INTEGER, NUMBER, LABEL,
      BOOLERR, FORMULA, ARRAY, STRING,
      TABLE, TABLE2
   PROTECT
   WINDOW PROTECT
   PASSWORD
   NOTE
   WINDOW1
   WINDOW2
   PANE
   SELECTION
   EOF

Finding Values From BIFF Files
------------------------------
  This section explains how to look up a cell value in a BIFF file,
  without having to load the file into Excel. You can look up values
  only in BIFF files that are not password-protected; protected BIFF
  files are encrypted and cannot be read.

  One way to find the value of a particular cell in a BIFF file is to
  read every BIFF record, until we find a cell record for the cell.  If
  we find one, we return its value. If we reach the EOF record without
  finding a cell record for the cell, then we return zero.

  Fortunately, we don't have to go through such an exhaustive search.