SpreadsheetML

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

With the introduction of SpreadsheetML the creation and processing of Microsoft Excel files is simplified. Competitive products and customized software applications to create SpreadsheetML documents, read and modify without having to access Microsoft Excel functions ..

Currently there are 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 stored in one (1) uncompressed XML file. These files consist mainly of four parts:

  • General Document Properties ( DocumentProperties )
  • Application-specific document properties ( Workbook )
  • Styles ( Styles)
  • Worksheets ( Worksheet )

SpreadsheetML 2003 does not support the entire Microsoft Excel functionality, it lacks the encouragement of charts, graphs and OLE objects.

Example

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

File Contents ( abridged):

< 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 " >               N.N. < / Author>          N.N.          2006-08 - 30T12: 00:00 Z          -          11.8036 < / Version>                    13225          19382          ⋮      < / Excel Workbook >