summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/basic
diff options
context:
space:
mode:
Diffstat (limited to 'test/xls-xml/basic')
-rw-r--r--test/xls-xml/basic/check.txt27
-rw-r--r--test/xls-xml/basic/input.xml112
2 files changed, 139 insertions, 0 deletions
diff --git a/test/xls-xml/basic/check.txt b/test/xls-xml/basic/check.txt
new file mode 100644
index 0000000..7e198a8
--- /dev/null
+++ b/test/xls-xml/basic/check.txt
@@ -0,0 +1,27 @@
+Data/0/0:string:"Numbers"
+Data/0/2:string:"Fractions"
+Data/0/4:string:"Text"
+Data/1/0:numeric:1
+Data/1/2:numeric:1.1
+Data/1/4:string:"A"
+Data/2/0:numeric:2
+Data/2/2:numeric:1.2
+Data/2/4:string:"B"
+Data/3/0:numeric:3
+Data/3/2:numeric:1.3
+Data/3/4:string:"C"
+Data/4/0:numeric:4
+Data/4/2:numeric:1.4
+Data/4/4:string:"D"
+Data/5/0:numeric:5
+Data/5/2:numeric:1.5
+Data/5/4:string:"E"
+Data/6/0:numeric:6
+Data/6/2:numeric:1.6
+Data/6/4:string:"F"
+Data/8/0:string:"One"
+Data/8/1:string:"Two"
+Data/8/2:string:"Three"
+Data/8/3:string:"Four"
+Data/8/4:string:"Five"
+2nd/0/0:string:"Empty Sheet"
diff --git a/test/xls-xml/basic/input.xml b/test/xls-xml/basic/input.xml
new file mode 100644
index 0000000..6484f68
--- /dev/null
+++ b/test/xls-xml/basic/input.xml
@@ -0,0 +1,112 @@
+<?xml version="1.0"?>
+<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">
+ <Author>Kohei Yoshida</Author>
+ <LastAuthor>Kohei Yoshida</LastAuthor>
+ <Created>2013-06-15T21:47:21Z</Created>
+ <Company>SUSE</Company>
+ <Version>10.2625</Version>
+ </DocumentProperties>
+ <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
+ <DownloadComponents/>
+ <LocationOfComponents HRef="file:///D:\"/>
+ </OfficeDocumentSettings>
+ <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+ <WindowHeight>9525</WindowHeight>
+ <WindowWidth>14355</WindowWidth>
+ <WindowTopX>240</WindowTopX>
+ <WindowTopY>30</WindowTopY>
+ <ProtectStructure>False</ProtectStructure>
+ <ProtectWindows>False</ProtectWindows>
+ </ExcelWorkbook>
+ <Styles>
+ <Style ss:ID="Default" ss:Name="Normal">
+ <Alignment ss:Vertical="Bottom"/>
+ <Borders/>
+ <Font/>
+ <Interior/>
+ <NumberFormat/>
+ <Protection/>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Data">
+ <Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="9" x:FullColumns="1"
+ x:FullRows="1">
+ <Row>
+ <Cell><Data ss:Type="String">Numbers</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="String">Fractions</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">Text</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><Data ss:Type="Number">1</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="Number">1.1</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">A</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><Data ss:Type="Number">2</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="Number">1.2</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">B</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><Data ss:Type="Number">3</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="Number">1.3</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">C</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><Data ss:Type="Number">4</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="Number">1.4</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">D</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><Data ss:Type="Number">5</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="Number">1.5</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">E</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><Data ss:Type="Number">6</Data></Cell>
+ <Cell ss:Index="3"><Data ss:Type="Number">1.6</Data></Cell>
+ <Cell ss:Index="5"><Data ss:Type="String">F</Data></Cell>
+ </Row>
+ <Row ss:Index="9">
+ <Cell><Data ss:Type="String">One</Data></Cell>
+ <Cell><Data ss:Type="String">Two</Data></Cell>
+ <Cell><Data ss:Type="String">Three</Data></Cell>
+ <Cell><Data ss:Type="String">Four</Data></Cell>
+ <Cell><Data ss:Type="String">Five</Data></Cell>
+ </Row>
+ </Table>
+ <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>9</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+ <Worksheet ss:Name="2nd">
+ <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"
+ x:FullRows="1">
+ <Row>
+ <Cell><Data ss:Type="String">Empty Sheet</Data></Cell>
+ </Row>
+ </Table>
+ <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>1</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>