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 noteWINDOW1 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 alignmentOrder 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   EOFFinding 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.