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