excel.txt

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

  4   colMic   2  first column that has a default
          cell
  6   colMac   2  last column that has a default
          cell, plus 1
  8   rgrgbAttr   var  array of default cell attributes

  Description
   The COLUMN DEFAULT record is an optional record that controls
   the formats of cells that aren't defined on the worksheet.
   This is a space-saving technique. By specifying a default
   cell for a particular column, you are telling Excel that all
   undefined cells in the column should have the specified cell
   attributes.  Default cells do not affect the formats of cells
   that are explicitly defined.

   For example, if you want all of column C to be left-aligned,
   then you could define all 16,384 cells in the column and
   specify that each one be left-aligned. This would require a
   large amount of storage to represent all 16,384 cells. Or,
   you could simply set the default cell for column C to be
   left-aligned, and not define any cells at all in column C.

   The rgrgbAttr field is an array of rgbAttr fields, with the
   range of the array being colMic to colMac-1, inclusive.  Each
   rgbAttr field is 3 bytes long. See the "Cell Attributes"
   section for a description of the rgbAttr field.

   If the COLUMN DEFAULT record is present, it must appear in
   the file before any ROW records or cell records.

ROW record - row descriptor (type = 8)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row number
  6   colMic   2  first defined column in the row
  8   colMac   2  last defined column in the row,
          plus 1
  10  miyRw    2  row height
  12  irwMac   2  Microsoft internal use
  14  fDefault 1  =1 if the row has default cell
             attributes
          =0 otherwise
  15  dbRtcell 2  relative file offset to the cell
          records for this row
  17  rgbAttr  3  default cell attributes

  Description
   A ROW record describes a single row on an Excel document.
   colMic and colMac give the range of defined columns in the
   row.  miyRw is the row height in units of 1/20 of a point.
   irwMac is used by Microsoft Excel to optimize loading the
   file; if you are creating a BIFF file, set this field to 0.

   The miyRw field may have the 0x8000 bit set, indicating that
   the row is standard height.  The low 15 bits must still
   contain the row height.

   Each row can have default cell attributes which control the
   format of all undefined cells in the row. This is a space-
   saving technique. By specifying default cell attributes for a
   particular row, you are effectively formatting all the
   undefined cells in the row, but without using up memory for
   those cells. Default cell attributes do not affect the
   formats of cells that are explicitly defined.

   For example, if you want all of row 3 to be left-aligned,
   then you could define all 256 cells in the row and specify
   that each one be left-aligned. This would require storage for
   each of the 256 cells. Or, you could simply set the default
   cell for row 3 to be left-aligned, and not define any cells
   at all in row 3.

   The fDefault field indicates whether a default cell is
   present or not.  If it is, then rgbAttr contains the default
   cell attributes.  See the "Cell Attributes" section for a
   description of the rbgAttr field.

   dbRtcell is a relative file offset to the cell records for
   the row.  This is described in the section "Finding Values
   From BIFF Files."

BLANK record - blank cell (type = 1)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row
  6   col     2   column
  8   rgbAttr  3  cell attributes

  Description
   A BLANK record describes a cell with no formula or
   value.

   See the "Cell Attributes" section for a description of
   the rgbAttr field.

INTEGER record - cell with constant integer (type = 2)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row
  6   col     2   column
  8   rgbAttr  3  cell attributes
  11  w    2  unsigned integer value

  Description
   An INTEGER record describes a cell containing a constant
   unsigned integer in the range 0 - 65535. Negative numbers and
   numbers outside this range must be stored as NUMBER records.

   See the "Cell Attributes" section for a description of
   the rgbAttr field.

NUMBER record - cell with constant floating point number (type = 3)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row
  6   col     2   column
  8   rgbAttr  3  cell attributes
  11  num     8   floating point number value

  Description
   A NUMBER record describes a cell containing a constant
   floating point number.  The number is in 8-byte IEEE floating
   point format.

   See the "Cell Attributes" section for a description of
   the rgbAttr field.

LABEL record - cell with constant string (type = 4)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row
  6   col     2   column
  8   rgbAttr  3  cell attributes
  11  cch     1   length of the string
  12  rgch    var  the string

  Description
   A LABEL record describes a cell with a constant string.
   The string length is in the range 0 - 255.

   See the "Cell Attributes" section for a description of
   the rgbAttr field.

BOOLERR record - cell with constant boolean or error (type = 5)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row
  6   col     2   column
  8   rgbAttr  3  cell attributes
  11  bBoolErr 1  boolean or error value
  12  fError   1  specifies boolean or error
          =1 for error
          =0 for boolean

  Description
   A BOOLERR record describes a cell containing a constant
   boolean or error value.

   Boolean values are 1 for TRUE and 0 or FALSE.
   Error values are as follows:
      0   #NULL!
      7   #DIV/0!
      15  #VALUE!
      23  #REF!
      29  #NAME?
      36  #NUM!
      42  #N/A

   See the "Cell Attributes" section for a description of
   the rgbAttr field.

FORMULA record - cell with a formula (type = 6)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rw   2  row
  6   col     2   column
  8   rgbAttr  3  cell attributes
  11  num     8   current value of formula
  19  sbRecalc 1  recalc flag
          =0 if the formula is calculated
          =nonzero if the formula needs
             to be calculated
          =3 if the formula is part
             of a matrix that needs
             to be calculated
  20  cce     1   length of parsed expression
  21  rgce    var  parsed expression

  Description
   A FORMULA record describes a cell with a formula.

   The sbRecalc field tells us whether the formula needs to be
   recalculated upon loading the file.  Normally, when formulas
   are saved in BIFF files, they are fully calculated.  In some
   cases, however, this is not possible.  If the formula
   contains a circular reference or a "volatile" function which
   can never be considered truly calculated, like RAND() or
   NOW(), then we indicate that the formula needs to be
   calculated upon loading.

   Any nonzero value for sbRecalc indicates that the formula
   needs to be calculated.  The special value of 3 is reserved
   for FORMULA records belonging to cells which are part of
   matrices, when the entire matrix itself needs to be calculated.

   The num field contains the current value of the formula in 8-
   byte IEEE format. For formulas that evaluate not to numbers
   but to strings, booleans, or error values, the last two bytes
   of the num field will be 0xFFFF.  This covers the sign bit,
   the exponent, and four bits of the fraction.

   A boolean is stored in the num field as follows:
      Offset  Name    Size Contents
      ------  ----    ---- --------
      0   otBool   1  =1 always
      1       1   RESERVED - must be zero
      2   f    1  boolean value
      3       3   RESERVED - must be zero
      6   fExprO   2  =0xFFFF always

   An error is stored in the num field as follows:
      Offset  Name    Size Contents
      ------  ----    ---- --------
      0   otErr    1  =2 always
      1       1   RESERVED - must be zero
      2   err     1   error value
      3       3   RESERVED - must be zero
      6   fExprO   2  =0xFFFF always

   See the BOOLERR record for a description of boolean
   and error values.

   A string is stored in the num field as follows:
      Offset  Name    Size Contents
      ------  ----    ---- --------
      0   otString 1  =0 always
      1       5   RESERVED - must be zero
      6   fExprO   2  =0xFFFF always

   The string value itself is not stored in the num field;
   instead, it is stored in a separate BIFF record, the
   STRING record.

   The parsed expression is the cell's formula, stored in
   Excel's internal compressed format.  See the section
   "Excel Formulas" for an explanation.

   See the "Cell Attributes" section for a description of
   the rgbAttr field.

ARRAY record - array formula (type = 33)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rwFirst  2  first row of the array
  6   rwLast   2  last row of the array
  8   colFirst 1  first column of the array
  9   colLast  1  last column of the array
  10  sbRecalc 1  recalc flag
          =0 if the array is calculated
          =nonzero if the array needs
             to be calculated
  11  cce     1   length of parsed expression
  12  rgce    var  parsed expression

  Description
   An ARRAY record describes a formula which was array-entered
   into a range of cells. The range in which the array is
   entered is given by rwFirst, rwLast, colFirst, and colLast.

   The ARRAY record occurs directly after the FORMULA record
   for the upper left corner cell of the array, i.e. cell
   (rwFirst, colFirst).

   The sbRecalc field tells whether the array needs to be
   recalculated upon loading or not.  See the FORMULA record for
   a description of this field.  Note that in an ARRAY record,
   unlike a FORMULA record, sbRecalc will never have the value 3.

   The parsed expression is the array formula, stored in
   Excel's internal compressed format.  See the section
   "Excel Formulas" for an explanation.

CONTINUE record - (type = 60)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rgce    var  parsed expression

  Description
   Some parsed formulas are so long that they are split up into
   sections and written out as separate records. The first
   section appears in the FORMULA or ARRAY record; subsequent
   sections appear in CONTINUE records. Parsed expressions will
   be discussed in detail in future documents.

   Some EXTERNNAME records are also long enough to need CONTINUE
   records.

STRING record - string value of a formula (type = 7)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cch     1   length of the string
  5   rgch    var  the string

  Description
   A STRING record appears after a FORMULA record whose
   formula currently evaluates to a string.  If the formula
   is part of an array, then the STRING record occurs after
   the ARRAY record.

TABLE record - one-input table definition (type = 54)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rwFirst  2  first row of the table
  6   rwLast   2  last row of the table
  8   colFirst 1  first column of the table
  9   colLast  1  last column of the table
  10  sbRecalc 1  recalc flag
          =0 if the table is calculated
          =nonzero if the table needs
             to be calculated
  11  fRw     1   =1 if this is a row input table
          =0 if this is a column input table
  12  rwInp    2  row of the input cell
  14  colInp   2  column of the input cell

  Description
   A TABLE record describes a one-input row or column table
   created through the Data Table command.

   The area in which the table is entered is given by rwFirst,
   rwLast, colFirst, and colLast.  This is the interior of
   the table; it does not include the outer row or column,
   which contains table formulas or input values.

   The sbRecalc field tells whether the array needs to be
   recalculated upon loading or not.  See the FORMULA record for
   a description of this field.  Note that in an TABLE record,
   unlike a FORMULA record, sbRecalc will never have the value 3.

   fRw tells us whether the input cell is a row input cell
   or a column input cell.  In either case, the input cell
   is given by (rwInp, colInp).

   rwInp is -1 in the case where the input cell is a deleted
   reference, i.e. displays as #REF!.  colInp is unused in this
   case.

TABLE2 record - two-input table definition (type = 55)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rwFirst  2  first row of the table
  6   rwLast   2  last row of the table
  8   colFirst 1  first column of the table
  9   colLast  1  last column of the table
  10  sbRecalc 1  recalc flag
          =0 if the table is calculated
          =nonzero if the table needs
             to be calculated