将xml文件转换为Java中的excel

将xml文件转换为Java中的excel

关注
发信
关注(28)粉丝(399)

将xml文件转换为Java中的excel

本文介绍了将xml文件转换为Java中的excel的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我是Java的初学者，我需要将一个 xml 文件转换为excel。



我做了很多研究，我发现我必须使用 POI 库，但我不知道如何使用它，如果它是足够的或我需要另一件事。 / p>

我觉得我很困难，我需要你的帮助！

解决方案

这个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


  1. dom4j-1.6.1.jar

  2. stax-api-1.0.1.jar

  3. xmlbeans-2.3.0.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

  1. dom4j-1.6.1.jar
  2. stax-api-1.0.1.jar
  3. xmlbeans-2.3.0.jar

这篇关于将xml文件转换为Java中的excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

08-23 21:03
Powered by LMLPHP ©2024 将xml文件转换为Java中的excel 0.032393