分享程序员开发的那些事...
更新时间：2023-02-23 11:17:07
这个shogg让你开始，记住我已经使用apache POI编写XML文件 p>
我将这个xml文件作为参考的输入
本书>
< person>
< first> hussain< / first>
< last> hussain< / last>
< age> 21< / age>
< / person>
< person>
< first> akhtar< / first>
< last> akhtar< / last>
< age> 22< / age>
< / person>
< person>
< first> wahid< / first>
< last> wahid< / last>
< age> 23< / age>
< / person>
< / book>
package com.xmlParsing;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.w3c.dom。*;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import org.xml.sax.SAXException;
import org.xml.sax.SAXParseException;
public class ReadAndPrintXMLFile {
public static void main（String argv []）{
ArrayList< String> firstNames = new ArrayList< String>（）;
ArrayList< String> lastNames = new ArrayList< String>（）;
ArrayList< String> ages = new ArrayList< String>（）;
try {
DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance（）;
DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder（）;
文档doc = docBuilder.parse（new File（C：/Users/hussain.a/Desktop/book.xml））;
//规范化文本表示
doc.getDocumentElement（）。normalize（）;
System.out.println（文档的根元素是：\+ doc.getDocumentElement（）。getNodeName（）+\）;
NodeList listOfPersons = doc.getElementsByTagName（person）;
int totalPersons = listOfPersons.getLength（）;
System.out.println（Total no of people：+ totalPersons）;
（int s = 0; s< listOfPersons.getLength（）; s ++）
{
Node firstPersonNode = listOfPersons.item（s）;
if（firstPersonNode.getNodeType（）== Node.ELEMENT_NODE）
{
元素firstPersonElement =（Element）firstPersonNode;
NodeList firstNameList = firstPersonElement.getElementsByTagName（first）;
元素firstNameElement =（Element）firstNameList.item（0）;
NodeList textFNList = firstNameElement.getChildNodes（）;
System.out.println（First Name：+（（Node）textFNList.item（0））。getNodeValue（）。trim（））;
firstNames.add（（（Node）textFNList.item（0））。getNodeValue（）。trim（））;
NodeList lastNameList = firstPersonElement.getElementsByTagName（last）;
元素lastNameElement =（Element）lastNameList.item（0）;
NodeList textLNList = lastNameElement.getChildNodes（）;
System.out.println（Last Name：+（（Node）textLNList.item（0））。getNodeValue（）。trim（））;
lastNames.add（（（Node）textLNList.item（0））。getNodeValue（）。trim（））;
NodeList ageList = firstPersonElement.getElementsByTagName（age）;
元素ageElement =（Element）ageList.item（0）;
NodeList textAgeList = ageElement.getChildNodes（）;
System.out.println（Age：+（（Node）textAgeList.item（0））。getNodeValue（）。trim（））;
ages.add（（（Node）textAgeList.item（0））。getNodeValue（）。trim（））;
} // if子句的结尾
} // for for循环结束s var
for（String firstName：firstNames）
{
系统.out.println（firstName：+ firstName）;
}
（String lastName：lastNames）
{
System.out.println（lastName：+ lastName）;
}
for（String age：ages）
{
System.out.println（age：+ age）;
}
}
catch（SAXParseException err）
{
System.out.println（**解析错误+，行+ err.getLineNumber（）+，uri+ err.getSystemId（））;
System.out.println（+ err.getMessage（））;
}
catch（SAXException e）
{
异常x = e.getException（）;
（（x == null）？e：x）.printStackTrace（）;
}
catch（Throwable t）
{
t.printStackTrace（）;
}
XSSFWorkbook工作簿=新XSSFWorkbook（）;
XSSFSheet sheet = workbook.createSheet（Sample sheet）;
Map< String，Object []> data = new HashMap< String，Object []>（）; （int i = 0; i< firstNames.size（）; i ++）
{
data.put（i +，new Object [] {firstNames.get（i） lastNames.get（i）中，ages.get（ⅰ）}）;
}
设置< String> keyset = data.keySet（）;
int rownum = 0;
for（String key：keyset）{
Row row = sheet.createRow（rownum ++）;
Object [] objArr = data.get（key）;
int cellnum = 0;
for（Object obj：objArr）{
Cell cell = row.createCell（cellnum ++）;
if（obj instanceof Date）
cell.setCellValue（（Date）obj）;
else if（obj instanceof Boolean）
cell.setCellValue（（Boolean）obj）;
else if（obj instanceof String）
cell.setCellValue（（String）obj）;
else if（obj instanceof Double）
cell.setCellValue（（Double）obj）;
}
}
try {
FileOutputStream out = new FileOutputStream（new File（C：/Users/hussain.a/Desktop/book.xlsx） ）;
workbook.write（out）;
out.close（）;
System.out.println（Excel written successfully ..）;
} catch（FileNotFoundException e）{
e.printStackTrace（）;
} catch（IOException e）{
e.printStackTrace（）;
}
} //主要
}
确保添加了以下jar
I am a beginner in Java and I need to convert an xml file to excel.
I've made many research, I found that I have to use POI library but I am not sure of the way to use it and if it is sufficient or I need another thing.
I feel really that I am stuck and I need your help please!
this shoulg get you started , remember i have used apache POI to write XML files
I am taking this xml file as input for your reference
<book>
<person>
<first>hussain</first>
<last>hussain</last>
<age>21</age>
</person>
<person>
<first>akhtar</first>
<last>akhtar</last>
<age>22</age>
</person>
<person>
<first>wahid</first>
<last>wahid</last>
<age>23</age>
</person>
</book>
package com.xmlParsing;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.w3c.dom.*;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import org.xml.sax.SAXException;
import org.xml.sax.SAXParseException;
public class ReadAndPrintXMLFile {
public static void main(String argv[]) {
ArrayList<String> firstNames = new ArrayList<String>();
ArrayList<String> lastNames = new ArrayList<String>();
ArrayList<String> ages = new ArrayList<String>();
try {
DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder();
Document doc = docBuilder.parse(new File("C:/Users/hussain.a/Desktop/book.xml"));
// normalize text representation
doc.getDocumentElement().normalize();
System.out.println("Root element of the doc is :\" "+ doc.getDocumentElement().getNodeName() + "\"");
NodeList listOfPersons = doc.getElementsByTagName("person");
int totalPersons = listOfPersons.getLength();
System.out.println("Total no of people : " + totalPersons);
for (int s = 0; s < listOfPersons.getLength(); s++)
{
Node firstPersonNode = listOfPersons.item(s);
if (firstPersonNode.getNodeType() == Node.ELEMENT_NODE)
{
Element firstPersonElement = (Element) firstPersonNode;
NodeList firstNameList = firstPersonElement.getElementsByTagName("first");
Element firstNameElement = (Element) firstNameList.item(0);
NodeList textFNList = firstNameElement.getChildNodes();
System.out.println("First Name : "+ ((Node) textFNList.item(0)).getNodeValue().trim());
firstNames.add(((Node) textFNList.item(0)).getNodeValue().trim());
NodeList lastNameList = firstPersonElement.getElementsByTagName("last");
Element lastNameElement = (Element) lastNameList.item(0);
NodeList textLNList = lastNameElement.getChildNodes();
System.out.println("Last Name : "+ ((Node) textLNList.item(0)).getNodeValue().trim());
lastNames.add(((Node) textLNList.item(0)).getNodeValue().trim());
NodeList ageList = firstPersonElement.getElementsByTagName("age");
Element ageElement = (Element) ageList.item(0);
NodeList textAgeList = ageElement.getChildNodes();
System.out.println("Age : "+ ((Node) textAgeList.item(0)).getNodeValue().trim());
ages.add(((Node) textAgeList.item(0)).getNodeValue().trim());
}// end of if clause
}// end of for loop with s var
for(String firstName:firstNames)
{
System.out.println("firstName : "+firstName);
}
for(String lastName:lastNames)
{
System.out.println("lastName : "+lastName);
}
for(String age:ages)
{
System.out.println("age : "+age);
}
}
catch (SAXParseException err)
{
System.out.println("** Parsing error" + ", line "+ err.getLineNumber() + ", uri " + err.getSystemId());
System.out.println(" " + err.getMessage());
}
catch (SAXException e)
{
Exception x = e.getException();
((x == null) ? e : x).printStackTrace();
}
catch (Throwable t)
{
t.printStackTrace();
}
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("Sample sheet");
Map<String, Object[]> data = new HashMap<String, Object[]>();
for(int i=0;i<firstNames.size();i++)
{
data.put(i+"",new Object[]{firstNames.get(i),lastNames.get(i),ages.get(i)});
}
Set<String> keyset = data.keySet();
int rownum = 0;
for (String key : keyset) {
Row row = sheet.createRow(rownum++);
Object[] objArr = data.get(key);
int cellnum = 0;
for (Object obj : objArr) {
Cell cell = row.createCell(cellnum++);
if (obj instanceof Date)
cell.setCellValue((Date) obj);
else if (obj instanceof Boolean)
cell.setCellValue((Boolean) obj);
else if (obj instanceof String)
cell.setCellValue((String) obj);
else if (obj instanceof Double)
cell.setCellValue((Double) obj);
}
}
try {
FileOutputStream out = new FileOutputStream(new File("C:/Users/hussain.a/Desktop/book.xlsx"));
workbook.write(out);
out.close();
System.out.println("Excel written successfully..");
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}// end of main
}
make sure you have added the following jar