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 Signature

VBA Project

VML Drawings

Worksheet, Chart Sheet, Dialog Sheet, Macro Sheet

Volatile Dependencies

Workbook

Workbook

Package

Worksheet

Workbook

Worksheet Binary Index

Worksheet