📄 xls.txt
字号:
that the cell is a part of a matrix, and the entire matrix must be recalculated. Bytes 7
through 14 may contain a number, a Boolean value, an error code, or a string. The
following tables apply.
Case 1: Bytes 7 - 14 contain a Boolean value.
Byte Number Byte Description Contents (hex)
7 otBool 1
8 Reserved 0
9 Boolean value
10-12 Reserved 0
13-14 fExprO FFFFh
Case 2: Bytes 7 - 14 contain an error code.
Byte Number Byte Description Contents (hex)
7 otErr 2
8 Reserved 0
9 error code
10-12 Reserved 0
13-14 fExprO FFFFh
Case 3: Bytes 7 - 14 contain a string.
Byte Number Byte Description Contents (hex)
7 otString 0
8-12 Reserved 0
13-14 fExprO FFFFh
The string value itself is not stored in the field, but rather in a separate record of
the STRING type.
STRING 07h 7d
Record Type: STRING
Description: Value of a string in a formula
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Length of the string
1-256 (max) The string itself
The STRING record appears immediately after the FORMULA record that evaluates to the
string, unless the formula is in an array. In that case, the string record immediately
follows the ARRAY record.
ROW 08h 8d
Record Type: ROW
Description: Specifies a spreadsheet row
Record Body Length: 16 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Row number
2-3 First defined column in the row
4-5 Last defined column in the row plus 1
6-7 Row height
8-9 RESERVED 0
10 Default cell attributes byte
Default attributes 1
Not default attributes 0
11-12 Offset to cell records for this row
13-15 Cell attributes (rgbAttr) (see Table 2-3)
BOF 09h 9d
Record Type: BOF
Description: Beginning of file
Record Body Length: 4 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Version number
Excel 2
Multiplan 3
2-3 Document type
worksheet 10h
chart 20h
macro sheet 40h
If bit 8 of the version number byte pair is high (mask with 0100h to find out), the BIFF
file is a Multiplan document.
EOF 0Ah 10d
Record Type: EOF
Description: End of file
Record Body Length: 0 bytes
The EOF record is the last one in a BIFF file. It always takes the form 0A000000h.
INDEX 0Bh 11d
Record Type: INDEX
Description: Contains pointers to other records in the BIFF file, and defines the range
of rows used by the document. It is used to simplify searching a file for a particular
cell or name.
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-3 Absolute file position of first NAME record
4-5 First row that exists
6-7 Last row that exists plus 1
8-on Array of absolute file positions of the
blocks of ROW records.
The INDEX record is optional. If present, it must immediately follow the FILEPASS
record. IF there is no FILEPASS record, it must follow the BOF record.
CALCCOUNT 0Ch 12d
Record Type: CALCCOUNT
Description: Specifies the iteration count
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Iteration Count
CALCMODE 0Dh 13d
Record Type: CALCMODE
Description: Specifies the calculation mode
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Calculation mode
Manual 0
Automatic 1
Automatic, no tables -1
PRECISION 0Eh 14d
Record Type: PRECISION
Description: Specifies precision of calculations for document
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Document precision
precision as displayed 0
full precision 1
REFMODE 0Fh 15d
Record Type: REFMODE
Description: Specifies location reference mode
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Reference mode
R1C1 mode 0
A1 mode 1
DELTA 10h 16d
Record Type: DELTA
Description: Maximum change for an iterative model
Record Body Length: 8
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-7 Maximum change (IEEE format, see Appendix A)
ITERATION 11h 17d
Record Type: ITERATION
Description: Specifies whether iteration is on
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Iteration flag
Iteration off 0
Iteration on 1
PROTECT 12h 18d
Record Type: PROTECT
Description: Specifies whether the document is protected with a document password
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Document protection
Not protected 0
Protected 1
PASSWORD 13h 19d
Record Type: PASSWORD
Description: Contains encrypted document password
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Encrypted password
HEADER 14h 20d
Record Type: HEADER
Description: Specifies header string that appears at the top of every page when the
document is printed
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Length of string (bytes)
1-on Header string (ASCII)
FOOTER 15h 21d
Record Type: FOOTER
Description: Specifies footer string that appears at the bottom of every page when the
document is printed
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Length of string (bytes)
1-on Footer string (ASCII)
EXTERNCOUNT 16h 22d
Record Type: EXTERNCOUNT
Description: Specifies the number of documents referenced externally by an Excel
document
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Number of externally referenced documents
EXTERNSHEET 17h 23d
Record Type: EXTERNSHEET
Description: Specifies a document that is referenced externally by the Excel file.
There must be an EXTERNSHEET record for every external file counted by the EXTERNCOUNT
record.
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Length of document name
1-on Document name
The document name may be encoded. If so, its first character will be 0, 1 or 2.
0 indicates the document name is an external reference to an empty sheet.
1 indicates the document name has been translated to a less sys-tem-dependent name.
This feature is valuable for documents intended for a non-DOS environment.
2 indicates that the externally referenced document is, in fact, the current document.
NAME 18h 24d
Record Type: NAME
Description: User-defined name on the document
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Name attribute
Only bits 1 and 2 are ever nonzero.
Bit 1 is 1 if the name is a function or
command name on a macro sheet.
Bit 2 is 1 if the name definition
includes:
* A function that returns an array, such
as TREND or MINVERSE
* A ROW or COLUMN function
* A user-defined function
Name attribute
Meaningful only if bit 1 of
byte 0 is 1 (the name is a function or
command name). Only bits 0 and 1 are
ever nonzero.
Bit 0 is 1 if the name is a function.
Bit 1 is 1 if the name is a command.
2 Keyboard shortcut. Meaningful only if the
name is a command.
If no keyboard shortcut 0
If shortcut exists ASCII value
3 Length of the name text
4 Length of the name's definition
5-? Text of the name
?-? Name's definition (parsed) in internal
compressed format
? Length of the name's definition (duplicate)
All NAME records should appear together in a BIFF file.
WINDOW PROTECT 19h 25d
Record Type: WINDOW PROTECT
Description: Specifies whether a document's windows are protected
Record Body Length: 2 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Window protect flag
Not protected 0
Protected 1
VERTICAL PAGE BREAKS 1Ah 26d
Record Type: VERTICAL PAGE BREAKS
Description: Lists all column page breaks
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Number of page breaks
2-on Array containing a 2-byte integer for each
column that immediately follows a column page
break. Columns must be sorted in ascending
order.
HORIZONTAL PAGE BREAKS 1Bh 27d
Record Type: HORIZONTAL PAGE BREAKS
Description: Lists all row page breaks
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Number of page breaks
2-on Array containing a 2-byte integer for each
row that immediately follows a row page
break. Rows must be sorted in ascending
order.
NOTE 1Ch 28d
Record Type: NOTE
Description: Note associated with a cell
Record Body Length: Variable, maximum of 254
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Row of the note
2-3 Column of the note
4-5 Length of the note part of the record
6-on Text of the note
Notes longer than 2048 characters must be split among multiple records. All except the
last one will contain 2048 text characters. The last one will contain the overflow.
SELECTION 1Dh 29d
Record Type: SELECTION
Description: Specifies which cells are selected in a pane of a split window. It can
also specify selected cells in a window that is not split.
Record Body Length: Variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Number of pane
bottom right 0
top right 1
bottom left 2
top left 3
no splits 3
1-2 Row number of the active cell
3-4 Column number of the active cell
5-6 Reference number of the active cell
7-8 Number of references in the selection
9-on Array of references
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -