ceshishuju

最新推荐文章于 2025-08-14 08:54:38 发布

encurage52

最新推荐文章于 2025-08-14 08:54:38 发布

阅读量123

点赞数

文章标签： Java Excel XML Myeclipse json

本文介绍了一个使用Java实现从XML文件读取数据并将其写入Excel文件的应用案例。该程序利用jxl库处理Excel文件，并通过JDOM解析XML数据。具体步骤包括：初始化Excel工作簿和工作表，从XML中提取标签和对应的中文词条，然后将这些数据写入Excel。

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

package test;

import java.io.File;
import java.util.List;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import org.jdom.Document;
import org.jdom.input.SAXBuilder;

public class Excel {

/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
//  WriteExcel excel = new WriteExcel("");
  System.out.println(System.getProperty("user.dir"));

//   ReadXML doc = ReadXML.getInstance(System.getProperty("user.dir")+"//src//test//test_zh.xml");
//  ReadXML doc = new ReadXML();
  ReadXML doc1 = ReadXML.xml;
  doc1.getInstance(System.getProperty("user.dir"));
   List list = doc1.getID();

   WritableWorkbook book=
    Workbook.createWorkbook(new File("D:\\MyEclipse 6.0\\workspace\\json\\src\\test\\test.xls"));
//    book.
    //添加一个工作表
    WritableSheet sheet=book.createSheet("第一页",1);

    for( int i = 0; i< list.size(); i++)
    {
     List tagList = (List)list.get(0);
     List zhList = (List)list.get(1);
     sheet.addCell(new Label(0,0,"词条"));
     sheet.addCell(new Label(1,0,"中文"));
     for(int j = 0; j< tagList.size(); j++)
     {
      String str = (String)tagList.get(j);
      sheet.addCell(new Label(0,j,str));
//      sheet.addCell(new Label(1,0,"中文"));
     }

     for(int k = 0; k< zhList.size(); k++)
     {
      String str1 = (String)zhList.get(k);
      sheet.addCell(new Label(1,k,str1));
//      sheet.addCell(new Label(1,0,"中文"));
     }
    }

    book.write();
    book.close();

}

}
++++++++++++++++++++++++++++++++++++++++++++

package test;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileReader;
import java.io.InputStreamReader;
import java.io.Reader;
import java.util.ArrayList;
import java.util.List;

import org.jdom.Attribute;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.input.SAXBuilder;

public class ReadXML {

static Document doc;
static ReadXML xml;

public static ReadXML getReadXML()
{
  xml = new ReadXML();
  return xml;
}
public static void getInstance(String path) throws Exception
{
  File file = new File(path);
  if(file.isDirectory())
  {
   File[] fileList = file.listFiles();
   for(int i = 0 ; i < fileList.length ; i++)
   {
    File nodeFile = fileList[i];
    System.out.println(nodeFile);
    getInstance("00="+nodeFile.toString());
   }


  }
  else
  {
   String fileName = file.getName();
//   System.out.println(file.getPath());
   if(fileName.indexOf("zh") > 0)
   {
    getbuild(fileName);
   }
  }
//  return xml;
}

public static List getbuild(String path) throws Exception
{
//   xml = new ReadXML();
//  InputStreamReader isr = new InputStreamReader(new FileInputStream(path));


   Reader isr = new InputStreamReader(new FileInputStream(path),"UTF-8");
  SAXBuilder build = new SAXBuilder();
   doc = build.build(isr);
   isr.close();
   List tagList = new ArrayList();
   List zhList = new ArrayList();
   List enList = new ArrayList();
   List list = new ArrayList();
   Element root = doc.getRootElement();
   List<Element> elementlist = root.getChildren();
   for(int i = 0; i < elementlist.size(); i++)
   {
    Element child = elementlist.get(i);
    Attribute id = child.getAttribute("id");
    String idCon = id.getValue();
    String con = child.getValue();
    tagList.add(idCon);
    zhList.add(con);
    System.out.println(child.getValue());
//    System.out.println(child.getAttributeValue("id"));
    System.out.println(idCon);
   }
   list.add(tagList);
   list.add(zhList);
   return list;
//  return xml;
}

public static List getID()
{
  List tagList = new ArrayList();
  List zhList = new ArrayList();
  List enList = new ArrayList();
  List list = new ArrayList();
  Element root = doc.getRootElement();
  List<Element> elementlist = root.getChildren();
  for(int i = 0; i < elementlist.size(); i++)
  {
   Element child = elementlist.get(i);
   Attribute id = child.getAttribute("id");
   String idCon = id.getValue();
   String con = child.getValue();
   tagList.add(idCon);
   zhList.add(con);
   System.out.println(child.getValue());
//   System.out.println(child.getAttributeValue("id"));
   System.out.println(idCon);
  }
  list.add(tagList);
  list.add(zhList);
  return list;
}
}