This article presents XML Excel files. It is part of Excel file types.
Table of contents
Simplest file
The following is the minimum content that corresponds to a worksheet named "TEST", with value "AAA" in cell of 3rd row and 2nd column.
<?xml version="1.0"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"> <Worksheet ss:Name="TEST"> <Table> <Row ss:Index="3"> <Cell ss:Index="2"><Data ss:Type="String">AAA</Data></Cell> </Row> </Table> </Worksheet> </Workbook>
Format
To know what are all the possibilities, enter a workbook manually and save it as XML format, then open the file using Notepad for example.
File with 2 worksheets
<?xml version="1.0"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"> <Worksheet ss:Name="TEST"> <Table> <Row ss:Index="3"> <Cell ss:Index="2"><Data ss:Type="String">AAA</Data></Cell> </Row> </Table> </Worksheet> <Worksheet ss:Name="TEST2"> <Table> <Row ss:Index="3"> <Cell ss:Index="2"><Data ss:Type="String">BBB</Data></Cell> </Row> </Table> </Worksheet> </Workbook>