Page tree
Skip to end of metadata
Go to start of metadata

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>
  • No labels