说道

最新推荐文章于 2021-08-06 13:40:14 发布

星际的那边

最新推荐文章于 2021-08-06 13:40:14 发布

阅读量398

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/xiong1l/article/details/8235958

本文介绍了一个使用Java实现的简单程序，该程序能够从XML文件中读取数据，并将其转换为Excel格式。通过解析XML文件并逐条写入Excel表格，此工具适用于需要将XML数据迁移或转换为Excel格式的场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com;

import java.io.File;
import java.io.IOException;
import java.text.Format;
import java.util.Iterator;
import java.util.List;

import jxl.Workbook;
import jxl.write.WriteException;

import org.jdom2.Document;
import org.jdom2.Element;
import org.jdom2.JDOMException;
import org.jdom2.input.SAXBuilder;

public class TestXml2 {
public static void main(String[] args) throws IOException, WriteException, JDOMException {

int i=0;
int j=0;
int sum=0;
jxl.write.WritableWorkbook writebook=Workbook.createWorkbook(new File("ff.xls"));
System.out.println("创建文件成功！");

jxl.write.WritableSheet writesheet=writebook.createSheet("成员资料",0);
jxl.write.WritableCellFormat format=new jxl.write.WritableCellFormat();
format.setAlignment(jxl.format.Alignment.CENTRE);

SAXBuilder builder=new SAXBuilder();
Document document=builder.build("studentInfo.xml");
/*Document document=builder.build(TestXml2.class.getClassLoader()
.getResourceAsStream("dd.xml"));*/
Element root=document.getRootElement();
List content=root.getChildren();
Iterator iterator=content.iterator();

while(iterator.hasNext())
{
i++;
Object o=iterator.next();
if(o instanceof Element)
{
Element child=(Element)o;
List childContent=child.getChildren();
Iterator childIterator =childContent.iterator();

while(childIterator.hasNext())
{
Object p=childIterator.next();
System.out.println(p);
if (p instanceof Element)
{
Element data=(Element)p;
jxl.write.Label label=new jxl.write.Label(j,i,data.getTextTrim(),format);
jxl.write.Label label2=new jxl.write.Label(j,0,data.getName(),format);
writesheet.addCell(label);
writesheet.addCell(label2);

j++;

System.out.println("_____________");
}

}

j=0;

}
}
writebook.write();
writebook.close();
}
}