2.1.7 Part Enumeration
This section specifies the parts (section 2.1.2) of the Excel Binary File Format (.xlsb) package. Refer to File Structure (section 2.1) and Relationship (section 2.1.3) for information about packages, parts, implicit relationships, explicit relationships, and the package relationship part.
If a part is in Binary Interchange File Format (BIFF) format, the record sequence is specified using ABNF grammar. The first rule in each rule list comprises the entire record sequence for that part. Subsequent rules are fragments of the first rule.
Parts and their relationships are summarized in the following table:
|
Part |
Relationship Target of |
|---|---|
|
ActiveX |
Worksheet |
|
ActiveX Binary |
Worksheet |
|
Attached Toolbars |
Workbook |
|
Calculation Chain |
Workbook |
|
Chart |
Drawings |
|
Chart Drawing |
Chart |
|
Chart Sheet |
Workbook |
|
Comments |
Macro Sheet, Worksheet |
|
Control Properties |
SpreadsheetML control |
|
Custom Data |
Custom Data Properties |
|
Custom Data Properties |
Workbook |
|
Custom Property |
Macro Sheet, Worksheet |
|
Custom XML Data Storage |
Workbook |
|
Custom XML Data Storage Properties |
Custom XML Data Storage |
|
Custom XML Maps |
Workbook |
|
Diagram Colors |
Drawings |
|
Diagram Data |
Drawings |
|
Diagram Layout Definition |
Drawings |
|
Diagram Styles |
Drawings |
|
Dialog Sheet |
Workbook |
|
Digital Signature Origin |
Package |
|
Digital Signature XML Signature |
Digital Signature Origin |
|
Drawings |
Chart Sheet, Worksheet, Macro Sheet |
|
External Data Connections |
Workbook |
|
External Link |
Workbook |
|
File Properties, Core |
Package |
|
File Properties, Custom |
Package |
|
File Properties, Extended |
Package |
|
File Properties, Thumbnail |
Package |
|
Images |
Chart Sheet, Macro Sheet, Theme, VML Drawings, Worksheet |
|
International Macro Sheet |
Workbook |
|
Macro Sheet |
Workbook |
|
Macro Sheet Binary Index |
Macro Sheet |
|
Metadata |
Workbook |
|
Model |
Workbook |
|
OLE Object |
Dialog Sheet, External Link, Macro Sheet, Worksheet |
|
OLE Package |
Dialog Sheet, Macro Sheet, Worksheet |
|
PivotCache Definition |
PivotTable, Workbook |
|
PivotCache Records |
PivotCache Definition |
|
PivotTable |
Worksheet |
|
Printer Settings |
Chart Sheet, Dialog Sheet, Macro Sheet, Worksheet |
|
Query Table |
Table, Worksheet |
|
Revision Headers |
Workbook |
|
Revision Log |
Revision Headers |
|
Shared Strings |
Workbook |
|
Single Cell Tables |
Worksheet |
|
Slicer Cache |
Workbook |
|
Slicers |
Worksheet |
|
Sort Map |
Macro Sheet, Worksheet |
|
Styles |
Workbook |
|
Table |
Worksheet |
|
Theme |
Workbook |
|
Timeline Cache |
Workbook |
|
Timelines |
Worksheet |
|
User Names |
Workbook |
|
VBA Project |
Workbook |
|
VBA Project Agile Signature |
VBA Project |
|
VBA Project Signature |
VBA Project |
|
VML Drawings |
Worksheet, Chart Sheet, Dialog Sheet, Macro Sheet |
|
Volatile Dependencies |
Workbook |
|
Workbook |
Package |
|
Worksheet |
Workbook |
|
Worksheet Binary Index |
Worksheet |