diff options
Diffstat (limited to 'test/xls-xml/table-offset')
-rw-r--r-- | test/xls-xml/table-offset/check.txt | 7 | ||||
-rw-r--r-- | test/xls-xml/table-offset/input.xml | 50 |
2 files changed, 57 insertions, 0 deletions
diff --git a/test/xls-xml/table-offset/check.txt b/test/xls-xml/table-offset/check.txt new file mode 100644 index 0000000..faf6c69 --- /dev/null +++ b/test/xls-xml/table-offset/check.txt @@ -0,0 +1,7 @@ +Sheet1/1/2:string:"Title" +Sheet1/2/1:numeric:111 +Sheet1/2/2:string:"aaaa" +Sheet1/2/3:numeric:36251 +Sheet1/3/1:numeric:2222 +Sheet1/3/2:string:"bbbb" +Sheet1/3/3:numeric:36252 diff --git a/test/xls-xml/table-offset/input.xml b/test/xls-xml/table-offset/input.xml new file mode 100644 index 0000000..b3770ad --- /dev/null +++ b/test/xls-xml/table-offset/input.xml @@ -0,0 +1,50 @@ +<?xml version="1.0" encoding="UTF-8"?> +<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"> + <Styles> + <Style ss:ID="s1"> + <Font ss:Bold="1" ss:Color="#008000"/> + <NumberFormat ss:Format="0.00_ ;[Red]\-0.00\ "/> + </Style> + <Style ss:ID="s2"> + <Font ss:Color="red"/> + </Style> + <Style ss:ID="s3"> + <Font ss:Color="blue"/> + <NumberFormat ss:Format="yyyy/mm\-dd;@"/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:TopCell="2" ss:LeftCell="2" ss:DefaultColumnWidth="20" ss:ExpandedColumnCount="3"> + <Column ss:StyleID="s1" ss:AutoFitWidth="1"/> + <Column ss:StyleID="s2"/> + <Column ss:StyleID="s3" ss:Index="3" ss:AutoFitWidth="1"/> + <Row ss:StyleID="s1"> + <Cell ss:Index="2"> + <Data ss:Type="String">Title</Data> + </Cell> + </Row> + <Row> + <Cell> + <Data ss:Type="Number">111</Data> + </Cell> + <Cell> + <Data ss:Type="String">aaaa</Data> + </Cell> + <Cell> + <Data ss:Type="DateTime">1999-04-01</Data> + </Cell> + </Row> + <Row> + <Cell> + <Data ss:Type="Number">2222</Data> + </Cell> + <Cell> + <Data ss:Type="String">bbbb</Data> + </Cell> + <Cell> + <Data ss:Type="DateTime">1999-04-02T00:00:00.000</Data> + </Cell> + </Row> + </Table> + </Worksheet> +</Workbook> |