?? xls.txt
字號:
Byte Number Byte Description
0-1 First row in the reference
2-3 Last row in the reference
4 First column in the reference
5 Last column in the reference
FORMAT 1Eh 30d
Record Type: FORMAT
Description: Describes a picture format in a document. All FORMAT records must appear
together in a BIFF file.
Record Body Length: Variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Length of format string
1-on Picture format string
FORMATCOUNT 1Fh 31d
Record Type: FORMATCOUNT
Description: The number of standard FORMAT records in the file. There are 21 different
format records.
Record Body Length: 2 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Number of built in format records.
COLUMN DEFAULT 20h 32d
Record Type: COLUMN DEFAULT
Description: Specifies default cell attributes for cells in a particular column. The
default value is overriden for individual cells by a subsequent explicit definition.
Record Body Length: Variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Column number of first column for which a
default cell is being defined
2-3 Column number of last column for which a
default cell is being defined, plus 1.
4-on Array of cell attributes
ARRAY 21h 33d
Record Type: ARRAY
Description: Describes a formula entered into a range of cells as an array. Occurs
immediately after the FORMULA record for the upper left corner of the array.
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 First row of the array
2-3 Last row of the array
4 First column of the array
5 Last column of the array
6 Recalculation flag
Array is calculated 0
Needs to be calculated nonzero
7 Length of parsed expression
8-on Parsed expression (array formula)
1904 22h 34d
Record Type: 1904
Description: Specifies date system used on this spreadsheet
Record Body Length: 2 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Specifies date system used
1904 date system 1
anything else 0
EXTERNNAME 23h 35d
Record Type: EXTERNNAME
Description: An externally referenced name, referring to a work-sheet or macro sheet or
to a DDE topic. All EXTERNNAME records associated with a supporting document must
directly follow its EXTERNSHEET record.
Record Body Length: Variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Length of the name
1-on The name
When EXTERNNAME references a DDE topic, Excel may append its most recent values to the
EXTERNNAME record. If the record becomes too long to be contained in a single record,
it is split into multiple records, with CONTINUE records holding the excess.
COLWIDTH 24h 36d
Record Type: COLWIDTH
Description: Sets column width for a range of columns
Record Body Length: 3 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 First column in the range
1 Last column in the range
2-3 Column width in units of 1/256th of a
character
DEFAULT ROW HEIGHT 25h 37d
Record Type: DEFAULT ROW HEIGHT
Description: Specifies the height of all rows that are not defined explicitly
Record Body Length: 2 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Default row height in units of 1/20th of a
point
LEFT MARGIN 26h 38d
Record Type: LEFT MARGIN
Description: Specifies the left margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-7 Left margin (IEEE format, see Appendix A)
RIGHT MARGIN 27h 39d
Record Type: RIGHT MARGIN
Description: Specifies the right margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-7 Right margin (IEEE format, see Appendix A)
TOP MARGIN 28h 40d
Record Type: TOP MARGIN
Description: Specifies the top margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-7 Top margin (IEEE format, see Appendix A)
BOTTOM MARGIN 29h 41d
Record Type: BOTTOM MARGIN
Description: Specifies the bottom margin in inches when the document is printed
Record Body Length: 8 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-7 Bottom margin (IEEE format, see Appendix A)
PRINT ROW HEADERS 2Ah 42d
Record Type: PRINT ROW HEADERS
Description: Flag determines whether to include row and column headers on printout of
document
Record Body Length:
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Row and Column Header Print Flag
Do not print headers 0
Print headers 1
PRINT GRIDLINES 2Bh 43d
Record Type: PRINT GRIDLINES
Description: Flag determines whether to print gridlines on print-out of document
Record Body Length: 2
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Gridline Print Flag
Do not print gridlines 0
Print gridlines 1
FILEPASS 2Fh 47d
Record Type: FILEPASS
Description: Specifies a file password. If this record is present, the rest of the file
is encrypted. The file password specified here is distinct from the document password
specified by the PASSWORD record. If present, the FILEPASS record must immediately
follow the BOF record.
Record Body Length: ?
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-on ?
FONT 31h 49d
Record Type: FONT
Description: Describes an entry in the document's font table. A document may have up to
4 different fonts, numbered 0 to 3. Font records are written in the font table in the
order in which they are encountered in the file.
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (binary)
0-1 Height of the font (in 1/20ths of a point)
2-3 Font Attributes
First byte (reserved) 00000000b
Second byte
Bit 0 - bold 1b
Bit 1 - italic 1b
Bit 2 - underline 1b
Bit 2 - strikeout 1b
Bits 4-7 (reserved) 0000b
4 Length of font name
5-? Font name
FONT2 32h 50d
Record Type: FONT2
Description: System specific information about the font defined in the previous FONT
record. The FONT2 record is option-al.
Record Body Length: Variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-on ?
TABLE 36h 54d
Record Type: TABLE
Description: Describes a one-input row or column table created through the Data Table
command
Record Body Length: 12 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 First row of the table
2-3 Last row of the table
4 First column of the table
5 Last column of the table
6 Recalculation flag
Table is recalculated 0
Not recalculated nonzero
7 Row or column input table flag
Column input table 0
Row input table 1
8-9 Row of the input cell
10-11 Column of the input cell
The area given by the first and last rows and columns does not include the outer row or
column, which contains table formulas or input values. If the input cell is a deleted
reference, the row of the input cell, given by the bytes at offset 8 and 9, is -1.
TABLE2 37h 55d
Record Type: TABLE2
Description: Describes a two-input table created by the Data Table command. It is the
same as the TABLE record, except there is no distinction between a row input table and a
column input table, there are two input cells rather than one, and either may have a
value of -1, indicating a deleted reference.
Record Body Length: 16 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 First row of the table
2-3 Last row of the table
4 First column of the table
5 Last column of the table
6 Recalculation flag
Table is calculated 0
Needs recalculation nonzero
7 RESERVED - must be zero 0
8-9 Row of the row input cell
10-11 Column of the row input cell
12-13 Row of the column input cell
14-15 Column of the column input cell
CONTINUE 3Ch 60d
Record Type: CONTINUE
Description: Continuation of FORMULA, ARRAY, or EXTERNNAME records that are too long to
fit in a single record.
Record Body Length: variable
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-on Parsed expression
WINDOW1 3Dh 61d
Record Type: WINDOW1
Description: Basic window information. Locations are relative to the upper left corner
of the Microsoft Windows desktop, and are measured in units of 1/20th of a point.
Record Body Length: 9 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Horizontal position of the window
2-3 Vertical position of the window
4-5 Width of the window
6-7 Height of the window
8 Hidden attribute
Window is not hidden 0
Window is hidden 1
If you do not include a WINDOW1 record in your BIFF file, Excel will create a default
window in your document.
WINDOW2 3Eh 62d
Record Type: WINDOW2
Description: Advanced window information. The WINDOW2 record is optional. If present,
it must immediately follow the WINDOW1 record.
Record Body Length: 14 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0 Display Formulas
Display values 0
Display formulas 1
1 Display Grid
Do not display gridlines 0
Display gridlines 1
2 Display Row and Column Headers
Do not display headers 0
Display headers
3 Freeze window panes
Do not freeze panes 0
Freeze panes 1
4 Display zero values
Suppress display 0
Display zero values 1
5-6 Top row visible in the window
7-8 Leftmost column visible in the window
9 Row/column header and gridline color
Specified in next four bytes 0
Use window's default 1
foreground color.
10-13 Row/column headers and gridline color (RGB)
BACKUP 40h 64d
Record Type: BACKUP
Description: Specifies whether a BIFF file should be backed up
Record Body Length: 2 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Backup flag
Do not back up 0
Back up 1
PANE 41h 65d
Record Type: PANE
Description: Describes the number and position of unfrozen panes in a window. Panes are
created by horizontal and vertical splits, which are measured in units of 1/20th of a
point.
Record Body Length: 9 bytes
Record Body Byte Structure:
Byte Number Byte Description Contents (hex)
0-1 Horizontal position of the split, zero if none
2-3 Vertical position of the split, zero if none
4-5 Top row visible in the bottom pane
6-7 Leftmost column visible in the right pane
8 Pane number of the active pane
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -