SpreadsheetML - Revision history

Dan Tobias: /* Sample file */

2020-02-12T00:22:38Z

‎Sample file

Dan Tobias at 23:18, 24 April 2018

2018-04-24T23:18:37Z

Jsummers at 19:08, 24 August 2016

2016-08-24T19:08:13Z

Dan Tobias at 04:33, 25 November 2014

2014-11-25T04:33:23Z

Dan Tobias at 02:27, 3 April 2014

2014-04-03T02:27:01Z

Dan Tobias: /* Sample file */

2014-04-03T02:26:15Z

‎Sample file

Dan Tobias at 02:12, 3 April 2014

2014-04-03T02:12:11Z

Dan Tobias: Created page with "{{FormatInfo |formattype=electronic |subcat=Document |extensions={{ext|xml}} }} '''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an XML-based format whi..."

2014-04-03T02:08:32Z

Created page with "{{FormatInfo |formattype=electronic |subcat=Document |extensions={{ext|xml}} }} '''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an XML-based format whi..."

New page

{{FormatInfo
|formattype=electronic
|subcat=Document
|extensions={{ext|xml}}
}}
'''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an [[XML]]-based format which was introduced in Microsoft Office 2003 as one of the formats which could be chosen in the "Save As" feature to save spreadsheets, though not the default format (which was [[XLS]], a proprietary binary format). This is a different format from the [[XLSX]] format introduced in Office 2007, which consists of a [[ZIP]] archive of various files including XML. In contrast, SpreadsheetML is a single XML file, uncompressed, and is unable to store all features which can be present in an Excel spreadsheet.

Opening this file format in OpenOffice apparently requires a [[Java]] runtime environment.

== Identification ==

A SpreadsheetML file has the following header:

<?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"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

== Links ==
* [[Wikipedia:SpreadsheetML|Wikipedia article]]
* [http://msdn.microsoft.com/en-us/library/aa140066%28office.10%29.aspx XML Spreadsheet Reference (Microsoft)]
* [http://www.flax.co.uk/blog/2013/11/01/g-cloud-and-open-file-formats-a-cautionary-tale/ G-Cloud and open file formats, a cautionary tale]

[[Category:XML based file formats]]
[[Category:Microsoft]]

@@ Line 27: / Line 27: @@
 == Sample file ==
-* [http://www.dan.info/sampledata/XML_Spreadsheet_2003.xml Sample SpreadsheetML document (saved from Excel 2007)]
+* [https://www.dan.info/sampledata/XML_Spreadsheet_2003.xml Sample SpreadsheetML document (saved from Excel 2007)]
 == Links ==

@@ Line 4: / Line 4: @@
 |extensions={{ext|xml}}
 }}
-'''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an [[XML]]-based format which was introduced in Microsoft Office 2003 as one of the formats which could be chosen in the "Save As" feature to save spreadsheets, though not the default format (which was [[XLS]], a proprietary binary format). This is a different format from the [[XLSX]] format introduced in Office 2007, which consists of a [[ZIP]] archive of various files including XML. In contrast, SpreadsheetML is a single XML file, uncompressed, and is unable to store all features which can be present in an Excel spreadsheet. The 2007 versions are still capable of loading and saving SpreadsheetML, even if a different XML-based format is the default format. (However, the term "SpreadsheetML" has also sometimes been [http://officeopenxml.com/anatomyofOOXML-xlsx.php used] to describe XLSX format as well.)
+'''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an [[XML]]-based format which was introduced in [[Microsoft Office]] 2003 as one of the formats which could be chosen in the "Save As" feature to save spreadsheets, though not the default format (which was [[XLS]], a proprietary binary format). This is a different format from the [[XLSX]] format introduced in Office 2007, which consists of a [[ZIP]] archive of various files including XML. In contrast, SpreadsheetML is a single XML file, uncompressed, and is unable to store all features which can be present in an [[Microsoft Excel|Excel]] spreadsheet. The 2007 versions are still capable of loading and saving SpreadsheetML, even if a different XML-based format is the default format. (However, the term "SpreadsheetML" has also sometimes been [http://officeopenxml.com/anatomyofOOXML-xlsx.php used] to describe XLSX format as well.)
 Opening this file format in OpenOffice apparently requires a [[Java]] runtime environment.

@@ Line 4: / Line 4: @@
 |extensions={{ext|xml}}
 }}
-'''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an [[XML]]-based format which was introduced in Microsoft Office 2003 as one of the formats which could be chosen in the "Save As" feature to save spreadsheets, though not the default format (which was [[XLS]], a proprietary binary format). This is a different format from the [[XLSX]] format introduced in Office 2007, which consists of a [[ZIP]] archive of various files including XML. In contrast, SpreadsheetML is a single XML file, uncompressed, and is unable to store all features which can be present in an Excel spreadsheet. The 2007 versions are still capable of loading and saving SpreadsheetML, even if a different XML-based format is the default format.
+'''SpreadsheetML''', '''XML Spreadsheet 2003''', or '''XMLSS''', is an [[XML]]-based format which was introduced in Microsoft Office 2003 as one of the formats which could be chosen in the "Save As" feature to save spreadsheets, though not the default format (which was [[XLS]], a proprietary binary format). This is a different format from the [[XLSX]] format introduced in Office 2007, which consists of a [[ZIP]] archive of various files including XML. In contrast, SpreadsheetML is a single XML file, uncompressed, and is unable to store all features which can be present in an Excel spreadsheet. The 2007 versions are still capable of loading and saving SpreadsheetML, even if a different XML-based format is the default format. (However, the term "SpreadsheetML" has also sometimes been [http://officeopenxml.com/anatomyofOOXML-xlsx.php used] to describe XLSX format as well.)
 Opening this file format in OpenOffice apparently requires a [[Java]] runtime environment.

@@ Line 26: / Line 26: @@
 == Sample file ==
-* [http://www.dan.info/sampledata/XML_Spreadsheet_2003.xml Sample SpreadsheetXML document]
+* [http://www.dan.info/sampledata/XML_Spreadsheet_2003.xml Sample SpreadsheetML document (saved from Excel 2007)]
 == Links ==

@@ Line 2: / Line 2: @@
 |formattype=electronic
 |subcat=Document
 |extensions={{ext|xml}}
 }}

@@ Line 20: / Line 20: @@
    xmlns:html="http://www.w3.org/TR/REC-html40">
    <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
 == Links ==