Skip to content

OOXML: Structure

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

Structure of an OOXML spreadsheet

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

Source

Data types

  • Boolean, serialized in XML as "b"
  • Date, serialized in XML as "d"
  • 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