excel.txt

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

FONT record - document font (type = 49)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   dy   2  height of the font
  6   grbit    2  font attributes
  8   cch     1   length of font name
  9   rgch    var  the font name

  Description
   The FONT record describes an entry in the Excel document's
   font table.  There are up to four different fonts on an Excel
   document, numbered 0 to 3.  FONT records are read into the
   font table in the order in which they are encountered in the
   BIFF file.

   The dy field gives the height of the font in units of 1/20
   of a point.  grbit contains the font attributes as follows:

  Offset  Bits Mask   Name    Contents
  ------  ---- ----   ----    --------
  0   7-0  0xFF       RESERVED - must be zeros
  1   7-4  0xF0       RESERVED - must be zeros
   3  0x08 fStrikeout  =1 if the font is struck
              out
   2  0x04 fUnderline  =1 if the font is
              underlined
   1  0x02 fItalic    =1 if the font is italic
   0  0x01 fBold   =1 if the font is bold

   cch and rgch contain the font's face name.

FONT2 record - more font information (type = 50)
  Description
   The FONT2 record contains system-specific information about
   the font defined in the previous FONT record. This record is
   optional.  If you are writing a BIFF file, do not write a
   FONT2 record.

HEADER record - print header string (type = 20)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cch     1   length of string
  5   rgch    var  the string

  Description
   The HEADER record specifies a print header string for a
   document.  This string appears at the top of every page
   when the document is printed.

FOOTER record - print footer string (type = 21)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cch     1   length of string
  5   rgch    var  the string

  Description
   The FOOTER record specifies a print footer string for a
   document.  This string appears at the bottom of every
   page when the document is printed.

LEFT MARGIN record - left print margin (type = 38)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   num     8   left margin

  Description
   The LEFT MARGIN record specifies the left margin in inches
   when a document is printed.  The num field is in 8-byte IEEE
   floating point format.

RIGHT MARGIN record - (type = 39)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   num     8   right margin

  Description
   The RIGHT MARGIN record specifies the right margin in inches
   when a document is printed.  The num field is in 8-byte IEEE
   floating point format.

TOP MARGIN record - (type = 40)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   num     8   top margin

  Description
   The TOP MARGIN record specifies the top margin in inches when
   a document is printed.  The num field is in 8-byte IEEE
   floating point format.

BOTTOM MARGIN record - (type = 41)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   num     8   bottom margin

  Description
   The BOTTOM MARGIN record specifies the bottom margin in
   inches when a document is printed.  The num field is in 8-
   byte IEEE floating point format.

COLWIDTH record - column width (type = 36)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   colFirst 1  first column in the range
  5   colLast  1  last column in the range
  6   dx   2  column width

  Description
   The COLWIDTH record sets the column width for a range of
   columns specified by colFirst and colLast.  The dx field is
   an unsigned integer specifying the column width in units of
   1/256 of a character.

EXTERNCOUNT record - count of externally referenced documents (type = 22)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cxals    2  number of externally referenced
          documents

  Description
   The EXTERNCOUNT record specifies the number of documents that
   are referenced externally from an Excel document.

   Both external references and Dynamic Data Exchange (DDE)
   references are counted here.  For external references, only
   the supporting sheet name counts.  For DDE references, the
   application-topic pair counts.

   For example, suppose a worksheet contains the following
   formulas:
      =SALES.XLS!Gross-SALES.XLS!Profits
      =Signal|System!Formats
      =Signal|StockInfo!IBM

   This worksheet would have an EXTERNCOUNT of three: SALES.XLS,
   Signal|System, and Signal|StockInfo.

EXTERNSHEET record - externally referenced document (type = 23)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cch     1   length of document name
  5   rgch    var  document name

  Description
   The EXTERNSHEET record specifes a document which is
   referenced externally from an Excel document.  There must be
   as many EXTERNSHEET records in a BIFF file as were specified
   in the EXTERNCOUNT record. The order of EXTERNSHEET records
   in a BIFF file is important and should not be changed.

   The document that is externally referenced is called the
   supporting document.  The document which refers to it is
   called the dependent document.

   The cch field gives the length of the supporting document
   name, which is contained in the rgch field. Whenever
   possible, document names are encoded to make BIFF files
   compatible with file systems other than DOS.  Encoded
   document names are identified by the first character of the
   rgch field.  The following special characters are recognized:

   Name    Value  Meaning
   ----    -----  -------
   chEmpty    0   empty sheetname
   chEncode   1   encoded pathname
   chSelf     2   self-referential external
          reference

   chEmpty is used to store an external reference to the empty
   sheet, as in the formula =!$A$1.  chSelf is used to store an
   external reference where the dependent and supporting
   documents are the same, for example a worksheet SALES.XLS
   which contains the formula =SALES.XLS!$A$1.

   chEncode is used when the DOS file name of the supporting
   document has been translated to a less system-dependent name.
   The following special characters are recognized in an encoded
   document name:

   Name    Value  Related DOS keys
   ----    -----  ----------------
   chVolume   1   :
   chSameVolume   2   none
   chDownDir  3   .\
   chUpDir    4   ..\

   The chVolume key is used to specify a DOS drive letter in a
   document name.  It is followed by the drive letter. This
   replaces the DOS-specific ':' character, as in
   =C:SALES.XLS!Gross.

   The chSameVolume key is used when the drive letter was
   omitted, to indicate that the supporting document is on the
   same DOS drive as the dependent document, as in
   =SALES.XLS!Gross.

   The chDownDir key is used to go down a directory level.  It
   is followed by the subdirectory name.  This replaces the
   implicit DOS-specific sequence ".\", meaning subdirectory of
   the current directory.  An example of such an external
   reference is =AUGUST\SALES.XLS!Gross.

   The chUpDir key is used to go up a directory level.  It
   replaces the DOS-specific sequence "..\", meaning the parent
   directory of the current directory.

   DDE references are encoded differently.  Only one translation
   is ever performed on a DDE reference, on the '|' character:

   Name    Value  Related DOS keys
   ----    -----  ----------------
   chDde   3  |

EXTERNNAME record - externally referenced name (type = 35)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cch     1   length of the name
  5   rgch    var  the name

  Description
   The EXTERNNAME record specifes a name which is referenced
   externally from an Excel document. All EXTERNNAME records
   associated with a supporting document must directly follow
   the EXTERNSHEET record for the document.

   The order of EXTERNNAME records in a BIFF file is important
   and should not be changed.

   An externally referenced name is one of the following:
      - A worksheet or macro sheet name in an external
        reference.  In the formula =SALES.XLS!Gross, the
        name "Gross" is an externally referenced name.
      - A DDE topic.  In the formula =Signal|StockInfo!IBM,
        the topic "IBM" is an externally referenced name.

   When the externally referenced name is a DDE topic, Excel may
   append the most recent values for the topic to the EXTERNNAME
   record.  The values are written in the same format as array
   constant values in parsed expressions.  See the explanation
   of "ptgArray" in the "Operand Tokens - Base" section for a
   full description of this format.

   If there are many values, the EXTERNNAME record may
   become so long that it must be split into multiple records.
   In this case, the EXTERNNAME record will be followed by one
   or more CONTINUE records.

FORMAT record - cell format (type = 30)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   cch     1   length of format string
  5   rgch    var  picture format string

  Description
   The FORMAT record describes a picture format on the document.

   All the FORMAT records should appear together in a BIFF file.
   The order of FORMAT records in an existing BIFF file is
   important and should not be changed. You can add new formats
   to a file, but they should be added at the end of the FORMAT
   list.

NAME record - user-defined name (type = 24)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   grbit    1  name attributes
  5   grbitPli 1  name attributes
  6   chKey    1  keyboard shortcut
  7   cch     1   length of the name text
  8   cce     1   length of the name's definition
  9   rgch    var  text of the name
  var  rgce    var parsed expression for the name's
          definition
  var  cceDup     1   length of the name's definition
          (this is a duplicate of the cce
          field)

  Description
   The NAME record describes a user-defined name on the
   document. The cch field contains the length the name text;
   the text itself is in rgch.  cce is the length of the name
   definition, and rgce contains the definition.  The location
   of rgce within the record depends on the length of the name
   text.  Following rgce, the length of the name definition
   appears again.

   The name definition is stored in Excel's internal compressed
   format. See the section "Excel Formulas" for an explanation.

   The grbit field contains bit attributes of the name:

   Bits   Mask Name    Contents
   ----   ---- ----    --------
   7-3 0xF8       RESERVED - must be zeros
   2  0x04 fCalcExp   =1 if the name contains a
              complex function
           =0 otherwise
   1  0x02 fProc   =1 for a Function or
              Command name
           =0 otherwise
   0  0x01     RESERVED - must be zero

   The fCalcExp bit is set if the name definition contains one
   or more of the following:
      - A function that returns an array (e.g. TREND,
        MINVERSE)
      - The ROW or COLUMN function
      - A user-defined function

   The fProc bit is set if the name is a Function or Command
   name on a macro sheet.

   grbitPli and chKey are meaningful only when the fProc bit is
   set in the grbit field.  grbitPli contains bit attributes for
   Function or Command names:

   Bits   Mask Name    Contents
   ----   ---- ----    --------
   7-2 0xFC       RESERVED - must be zeros
   1  0x02 fRun    =1 for Command names
   0  0x01 fFunc   =1 for Function names

   chKey is the keyboard shortcut for a Command name.  If the
   name is not a command name or has no keyboard shortcut, then
   chKey will be 0.

   All the NAME records should appear together in a BIFF file.
   The order of NAME records in an existing BIFF file is
   important and should not be changed.  You can add new names
   to a file, but they should be added at the end of the NAME
   list. Excel saves out the names in alphabetical order, but
   this is not a requirement; Excel will sort the name list, if
   necessary, when it loads a BIFF file.

DIMENSIONS record - cell table size (type = 0)
  Offset  Name    Size Contents
  ------  ----    ---- --------
  4   rwMic    2  first defined row on the document
  6   rwMac    2  last defined row on the document,
          plus 1
  8   colMic   2  first defined column on the document
  10  colMac   2  last defined column on the document,
          plus 1

  Description
   The DIMENSIONS record contains the minimum and maximum bounds
   of the document. It tells us very quickly the approximate
   size of the document.

   Note that both the rwMac and colMac fields are 1 greater
   than the actual last row and column.  For example, for
   a worksheet that exists between cells B3 and D6, we would
   have rwMic = 2, colMic = 1, rwMac = 6, colMac = 4.

COLUMN DEFAULT record - default cell attributes (type = 32)
  Offset  Name    Size Contents
  ------  ----    ---- --------