Skip to content

OOXML: Structure

Jump to bottom
Asbjørn Skødt edited this page Sep 28, 2022 · 11 revisions

Structure of an OOXML spreadsheet

https://www.todaysoftmag.com/article/848/getting-started-with-openxml

Source

Content types

  • Calculation chain
  • Chartsheet
  • Comments
  • Connections
  • Custom property
  • Customer XML mappings
  • Dialogsheet
  • Drawings
  • External workbook references
  • Metadata
  • Pivot table
  • Pivot table cache definition
  • Pivot table cache records
  • Query table
  • Shared string table
  • Shared workbook revision log
  • Shared workbook user data
  • Single cell table definition
  • Styles
  • Table definition
  • Volatile dependencies
  • Workbook
  • Worksheet

Content types shared by OOXML standard

  • Embedded package
  • Extended file properties
  • File properties
  • Image
  • Theme

Source

Data types

  • Boolean, serialized in XML as "b"
  • Date, serialized in XML as "d"
    • The date is stored as a value in the ISO 8601 format.
  • Error, serialized in XML as "e"
  • InlineString, serialized in XML as "InlineStr"
    • Type used if string should not be stored in the SharedStringTable
  • Number, serialized in XML as "n"
  • SharedString, serialized in XML as "s"
    • A deduplicated string value that can be used by multiple cells
  • String, serialized in XML as "str"
    • Type used when cell contains formula

Encoding

Conformant OOXML spreadsheets must be encoded in UTF-8 or UTF-16.

Standards

Clone this wiki locally