java 怎樣解析 excel生成的xml文件

dom4j是壹個簡單的開源庫，用於處理XML、 XPath和XSLT，它基於Java平臺，使用Java的集合框架，全面集成了DOM，SAX和JAXP。

1、excel生成的xml樣例文件：

<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<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=":office:office">

<Created>2006-09-16T00:00:00Z</Created>

<LastSaved>2016-07-25T03:26:50Z</LastSaved>

<Version>14.00</Version>

</DocumentProperties>

<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

<AllowPNG/>

<RemovePersonalInformation/>

</OfficeDocumentSettings>

<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

<WindowHeight>7956</WindowHeight>

<WindowWidth>14808</WindowWidth>

<WindowTopX>240</WindowTopX>

<WindowTopY>168</WindowTopY>

<ActiveSheet>2</ActiveSheet>

<ProtectStructure>False</ProtectStructure>

<ProtectWindows>False</ProtectWindows>

</ExcelWorkbook>

<Styles>

<Style ss:ID="Default" ss:Name="Normal">

<Alignment ss:Vertical="Bottom"/>

<Borders/>

<Font ss:FontName="宋體" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>

<Interior/>

<NumberFormat/>

<Protection/>

</Style>

<Style ss:ID="s16" ss:Name="好">

<Font ss:FontName="宋體" x:CharSet="134" ss:Size="11" ss:Color="#006100"/>

<Interior ss:Color="#C6EFCE" ss:Pattern="Solid"/>

</Style>

<Style ss:ID="s17">

<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:Indent="1"

ss:WrapText="1"/>

<Font ss:FontName="宋體" x:CharSet="134" ss:Size="8" ss:Color="#686868"/>

<NumberFormat ss:Format="@"/>

</Style>

<Style ss:ID="s18" ss:Parent="s16">

<Alignment ss:Vertical="Bottom"/>

</Style>

<Style ss:ID="s19">

<NumberFormat ss:Format="yyyy/m/d\ h:mm:ss"/>

</Style>

</Styles>

<Worksheet ss:Name="Sheet1">

<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="3" x:FullColumns="1"

x:FullRows="1" ss:DefaultRowHeight="14.4">

<Row>

<Cell><Data ss:Type="String">工號</Data></Cell>

<Cell><Data ss:Type="String">姓名 </Data></Cell>

<Cell ss:Index="5"><Data ss:Type="String">工號</Data></Cell>

<Cell><Data ss:Type="String">姓名</Data></Cell>

</Row>

<Row>

<Cell><Data ss:Type="Number">111</Data></Cell>

<Cell><Data ss:Type="String">張三</Data></Cell>

<Cell ss:Index="5"><Data ss:Type="Number">111</Data></Cell>

<Cell ss:Formula="=VLOOKUP(R2C5:R3C5,RC[-5]:R[1]C[-4],2)"><Data

ss:Type="String">張三</Data></Cell>

</Row>

<Row>

<Cell><Data ss:Type="Number">112</Data></Cell>

<Cell><Data ss:Type="String">李四</Data></Cell>

<Cell ss:Index="5"><Data ss:Type="Number">112</Data></Cell>

<Cell ss:Formula="=VLOOKUP(R2C5:R3C5,RC[-5]:R[1]C[-4],2)"><Data

ss:Type="String">李四</Data></Cell>

</Row>

</Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<PageSetup>

<Header x:Margin="0.3"/>

<Footer x:Margin="0.3"/>

<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>

</PageSetup>

<Panes>

<Pane>

<Number>3</Number>

<ActiveRow>7</ActiveRow>

<ActiveCol>5</ActiveCol>

</Pane>

</Panes>

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

</Workbook>

2、java解析代碼：

import java.io.File;

import java.util.Iterator;

import org.dom4j.Attribute;

import org.dom4j.Document;

import org.dom4j.Element;

import org.dom4j.io.SAXReader;

public class Demo {

public static void main(String[] args) throws Exception {

SAXReader reader = new SAXReader();

Document document = reader.read(new File("person.xml"));

Element root = document.getRootElement();

Iterator it = root.elementIterator();

while (it.hasNext()) {

Element element = (Element) it.next();

//未知屬性名稱情況下

/*Iterator attrIt = element.attributeIterator();

while (attrIt.hasNext()) {

Attribute a = (Attribute) attrIt.next();

System.out.println(a.getValue());

}*/

//已知屬性名稱情況下

System.out.println("id: " + element.attributeValue("id"));

//未知元素名情況下

/*Iterator eleIt = element.elementIterator();

while (eleIt.hasNext()) {

Element e = (Element) eleIt.next();

System.out.println(e.getName() + ": " + e.getText());

}

System.out.println();*/

//已知元素名情況下

System.out.println("title: " + element.elementText("title"));

System.out.println("author: " + element.elementText("author"));

System.out.println();

}

}

}