OOXML: Structure

Structure of an OOXML spreadsheet

Source

• Getting started with OpenXML

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"
• Number, serialized in XML as "n"
• SharedString, serialized in XML as "s"
• String, serialized in XML as "str"

Standards

• ISO/IEC 29500-1:2016 - Part 1: Fundamentals and Markup Language Reference
• ISO/IEC 29500-2:2021 - Part 2: Open packaging conventions
• ISO/IEC 29500-3:2015 - Part 3: Markup Compatibility and Extensibility
• ISO/IEC 29500-4:2016 - Part 4: Transitional Migration Features