java解析xml文件并写入Excel表

最新推荐文章于 2024-05-16 15:09:42 发布

Fantasy嘿

最新推荐文章于 2024-05-16 15:09:42 发布

阅读量1.2k

点赞数

文章标签： java xml excel

本文链接：https://blog.csdn.net/weixin_50794535/article/details/127805704

版权

解析xml文件并写入Excel表

类似于如下格式的xml数据，解析之后将数据写入Excel中

<?xml version="1.0" encoding="UTF-8"?>
<DATASETS>
    <DATASET>
        <education>undergraduate</education>
        <occupation>programmer</occupation>
        <name>张三</name>
        <weight>150</weight>
        <age>23</age>
        <height>173</height>
        <hobby>basketball</hobby>
    </DATASET>
    <DATASET>
        <education>undergraduate</education>
        <occupation>programmer</occupation>
        <name>王一</name>
        <weight>120</weight>
        <age>22</age>
        <height>168</height>
        <hobby>game</hobby>
    </DATASET>
    <DATASET>
        <education>undergraduate</education>
        <occupation>programmer</occupation>
        <name>魏某</name>
        <weight>125</weight>
        <age>22</age>
        <height>170</height>
        <hobby>novel</hobby>
    </DATASET>
</DATASETS>

一. 构建springboot项目，导入依赖

 <!--JDom解析xml -->
 <dependency>
      <groupId>org.jdom</groupId>
      <artifactId>jdom</artifactId>
      <version>1.1.3</version>
  </dependency>
 <!--   读写Excel文件依赖     -->
  <dependency>
      <groupId>org.apache.poi</groupId><