Usage
This program reads a file generated by Microsoft Excel and generate a representation of its contents using XML.
Usage:
xls2xml xlsFILE [xmlFILE] [--refmode=(A1|R1C1|default)] [--level=(all|normal)]
xlsFILE. It's the only required parameter. It's the file name of the file generated by Microsoft Excel.
xmlFILE. It's the file name where the XML result is stored. If it is ommited, the result is written in the standard output.
--refmode=(A1|R1C1|default). Which cell reference mode will be used: A1 is the most common, R1C1 is also available, and default is the reference mode used in the file generated by Microsoft Excel.
--level=(all|normal). How much content will be extracted.
Sample output
Next is an typical output. You can note that the cell contents are under "fil_spreadsheet/sheets/sheet/cells" tags. Note that the cell content are UTF8 encoded. Note that if xls2xml can't understand some formula, it outputs a error message in the cell.
<?xml version="1.0"?>
<fil_spreadsheet>
<defaults>
<tabsstate>
<order>0,1,2</order>
<top>0</top>
<first>0</first>
<howmanyselected>1</howmanyselected>
<widthratiovshorizscrollbar>600</widthratiovshorizscrollbar>
</tabsstate>
<building>
<appid>3612</appid>
<appyear>1996</appyear>
<lasteditedWin/>
<evereditedWin/>
</building>
<ui/>
<codepage>1200</codepage>
<username>John Dow</username>
<windowstate>
<metrics>
<xpos>2685</xpos>
<ypos>65386</ypos>
<width>9180</width>
<height>5010</height>
</metrics>
<display>
<hidden>no</hidden>
<iconic>no</iconic>
<horizscrollbar>yes</horizscrollbar>
<vertscrollbar>yes</vertscrollbar>
<tabs>yes</tabs>
</display>
</windowstate>
<backup>no</backup>
<showobjects>yes</showobjects>
<precisionasdisplayed>no</precisionasdisplayed>
<fonts>
<font refnum="0">
<height>200</height>
<italic>no</italic>
<strikeout>no</strikeout>
<outline>no</outline>
<shadow>no</shadow>
<bold type="yesno">no</bold>
<pos>normal</pos>
<underline>no</underline>
<family type="numeric">0</family>
<name>Arial</name>
</font>
<font refnum="1">
<height>200</height>
<italic>no</italic>
<strikeout>no</strikeout>
<outline>no</outline>
<shadow>no</shadow>
<bold type="yesno">no</bold>
<pos>normal</pos>
<underline>no</underline>
<family type="numeric">0</family>
<name>Arial</name>
</font>
<font refnum="2">
<height>200</height>
<italic>no</italic>
<strikeout>no</strikeout>
<outline>no</outline>
<shadow>no</shadow>
<bold type="yesno">no</bold>
<pos>normal</pos>
<underline>no</underline>
<family type="numeric">0</family>
<name>Arial</name>
</font>
<font refnum="3">
<height>200</height>
<italic>no</italic>
<strikeout>no</strikeout>
<outline>no</outline>
<shadow>no</shadow>
<bold type="yesno">no</bold>
<pos>normal</pos>
<underline>no</underline>
<family type="numeric">0</family>
<name>Arial</name>
</font>
</fonts>
</defaults>
<sheets>
<sheet refnum="0">
<cells>
<cell volatile="no" coord="A1">=7</cell>
<cell coord="B1">"7 seven special-characters-áéíóúÁÉÍÓÚñÑ 7+8 SIN(7) SIN(7)+8 CHOOSE(1,SIN(1),SIN(2),SIN(3)) CHOOSE(2,SIN(1),SIN(2),SIN(3)) CHOOSE(3,SIN(1),SIN(2),SIN(3)) 7.1 12345678912345.1 7.1+7.2 12345678912345.1+12345678912345.1 5+6+1.1 1+2-3*4/5 SIN(1.1) COS(1.1) TAN(1.1) A13+$A14+A$5+$A$6 1+1.1*-A1 -1.1-1.2+(-1.3)"</cell>
<cell volatile="no" coord="A2">="seven"</cell>
<cell volatile="no" coord="A3">="special-characters-áéíóúÁÉÍÓÚñÑ"</cell>
<cell volatile="no" coord="A4">=7+8</cell>
<cell volatile="no" coord="A5">=SIN(7)</cell>
<cell volatile="no" coord="A6">=SIN(7)+8</cell>
<cell volatile="no" coord="A7">Formula error: unknown formula</cell>
<cell volatile="no" coord="A8">Formula error: unknown formula</cell>
<cell volatile="no" coord="A9">Formula error: unknown formula</cell>
<cell volatile="no" coord="A10">=7.100000</cell>
<cell volatile="no" coord="A11">=12345678912345.099609</cell>
<cell volatile="no" coord="A12">=7.100000+7.200000</cell>
<cell volatile="no" coord="A13">=12345678912345.099609+12345678912345.099609</cell>
<cell volatile="no" coord="A14">=5+6+1.100000</cell>
<cell volatile="no" coord="A15">=1+2-3*4/5</cell>
<cell volatile="no" coord="A16">=SIN(1.100000)</cell>
<cell volatile="no" coord="A17">=COS(1.100000)</cell>
<cell volatile="no" coord="A18">=TAN(1.100000)</cell>
<cell volatile="no" coord="A19">=A13+$A14+A$5+$A$6</cell>
<cell volatile="no" coord="A20">=1+1.100000*-(A1)</cell>
<cell volatile="no" coord="A21">=-1.100000-1.200000+(-1.300000)</cell>
</cells>
<name>Hoja1</name>
<hidden>no</hidden>
<calculationmode>auto</calculationmode>
<maxiterations>100</maxiterations>
<referencemode>a1</referencemode>
<takeiterationoptions>no</takeiterationoptions>
<iterationdelta>0.001000</iterationdelta>
</sheet>
<sheet refnum="1">
<cells/>
<name>Hoja2</name>
<hidden>no</hidden>
<calculationmode>auto</calculationmode>
<maxiterations>100</maxiterations>
<referencemode>a1</referencemode>
<takeiterationoptions>no</takeiterationoptions>
<iterationdelta>0.001000</iterationdelta>
</sheet>
<sheet refnum="2">
<cells/>
<name>Hoja3</name>
<hidden>no</hidden>
<calculationmode>auto</calculationmode>
<maxiterations>100</maxiterations>
<referencemode>a1</referencemode>
<takeiterationoptions>no</takeiterationoptions>
<iterationdelta>0.001000</iterationdelta>
</sheet>
</sheets>
</fil_spreadsheet>