SpreadsheetML

from Wikipedia, the free encyclopedia

SpreadsheetML is an XML -based markup language for spreadsheet documents developed by Microsoft for Microsoft Excel 2003 and later . SpreadsheetML is a further development of the XML-based file format XML Spreadsheet introduced with Microsoft Excel XP .

With the introduction of SpreadsheetML, creating and processing Microsoft Excel files is made easier. Competitive products and individual software applications should be able to create, import and modify SpreadsheetML documents without having to access Microsoft Excel functions.

There are currently two versions of SpreadsheetML, the 2003 version and the version that is part of the ISO / IEC standard 29500: 2008 ( Office Open XML ).

SpreadsheetML 2003

SpreadsheetML 2003 documents are saved in one (1) uncompressed XML file. These files essentially consist of four parts:

  • General document properties ( DocumentProperties )
  • Application-specific document properties ( WorkBook )
  • Format templates ( styles )
  • Worksheets ( worksheet )

SpreadsheetML 2003 does not support all of Microsoft Excel's functionality; it lacks support for charts, graphics and OLE objects, among other things.

example

Display on the screen (cell A3 contains the SUM of the two cells above):

A.
1 1
2 1
3 2

File content (shortened): 

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
          xmlns:o="urn:schemas-microsoft-com:office:office"
          xmlns:x="urn:schemas-microsoft-com:office:excel"
          xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
    <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
        <Author>N.N.</Author>
        <LastAuthor>N.N.</LastAuthor>
        <Created>2006-08-30T12:00:00Z</Created>
        <Company>-</Company>
        <Version>11.8036</Version>
    </DocumentProperties>
    <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
        <WindowHeight>13225</WindowHeight>
        <WindowWidth>19382</WindowWidth>
        ⋮
    </ExcelWorkbook>
    <Styles>
        <Style ss:ID="Default" ss:Name="Normal">
            <Alignment ss:Vertical="Bottom"/>
            <Borders/>
            <Font/>
            <Interior/>
            <NumberFormat/>
            <Protection/>
        </Style>
    </Styles>
    <Worksheet ss:Name="Tabelle1">
        <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="3" x:FullColumns="1"
               x:FullRows="1" ss:DefaultColumnWidth="66.206896551724142"
               ss:DefaultRowHeight="13.241379310344827">
            <Row>
                <Cell>
                    <Data ss:Type="Number">1</Data>
                </Cell>
            </Row>
            <Row>
                <Cell>
                    <Data ss:Type="Number">1</Data>
                </Cell>
            </Row>
            <Row>
                <Cell ss:Formula="=SUM(R[-2]C:R[-1]C)">
                    <Data ss:Type="Number">2</Data>
                </Cell>
            </Row>
        </Table>
        <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
            <PageSetup>
                <Header x:Margin="0.4921259845"/>
                <Footer x:Margin="0.4921259845"/>
                <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
                             x:Right="0.78740157499999996" x:Top="0.984251969"/>
            </PageSetup>
            <Selected/>
            <Panes>
                <Pane>
                    <Number>3</Number>
                    <ActiveRow>3</ActiveRow>
                </Pane>
            </Panes>
            <ProtectObjects>False</ProtectObjects>
            <ProtectScenarios>False</ProtectScenarios>
        </WorksheetOptions>
    </Worksheet>
    <Worksheet ss:Name="Tabelle2">
        ⋮
    </Worksheet>
    <Worksheet ss:Name="Tabelle3">
        ⋮
    </Worksheet>
</Workbook>

Standardization and Licensing

SpreadsheetML 2003 was not standardized by any standardization organization , so it is not a manufacturer-independent standard.

Full documentation is publicly available.

Microsoft grants a perpetual, royalty-free license to use SpreadsheetML. In a covenant not to sue , Microsoft has declared that it irrevocably waives any enforcement of all patents required for a compliant implementation of the Office 2003 XML Reference Schemas specification in relation to program parts that implement this specification. This does not apply to third party claims.

distribution

SpreadsheetML 2003 is supported by Microsoft Excel 2003, Microsoft Excel Viewer 2003, LibreOffice and Gnumeric , among others .

Office Open XML SpreadsheetML

Office Open XML SpreadsheetML is a new version of SpreadsheetML that is part of the Office Open XML standard. The standardization took place within the framework of the Technical Committee 45 (TC45) of Ecma International as well as within ISO / IEC. This markup language is a further development of SpreadsheetML 2003.

Web links

Individual evidence

  1. ↑ INFO: Microsoft Excel 2002 and XML Microsoft Knowledge Base (English)
  2. ^ Bringing the XML Vision to the Desktop with Office 2003 Microsoft
  3. ↑ Features and limitations of XML Spreadsheet format in Excel  ( page no longer available , search in web archives )  Info: The link was automatically marked as defective. Please check the link according to the instructions and then remove this notice. Microsoft@1@ 2Template: Dead Link / office.microsoft.com  
  4. ↑ Office 2003: XML Reference Schemas (English)
  5. ↑ Clarification of License Terms for Office XML Schema Microsoft (English)
  6. ↑ Microsoft Covenant Regarding Office 2003 XML Reference Schemas Microsoft