java 将EXCEL表格数据转换成XML格式

有时候我门需要把EXCEL表格中的数据转换成XML格式 这需要用到JXL(分析EXCEL)包和JDOM包(构成XML)

import java.io.*;
import jxl.*;
import org.jdom.Element;
import org.jdom.Document;
import org.jdom.output.XMLOutputter;

/**
 *
 * @author guo
 */
public class EtoX {
   
    /** Creates a new instance of EtoX */
    public EtoX() {
    }
   
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        try{           
           InputStream is= new FileInputStream("C://Documents and Settings//guo//EXCELtoXML//src//exceltoxml//ningxia.xls");
           Workbook rwb=Workbook.getWorkbook(is);
           //System.out.println(rwb.getNumberOfSheets());     //获得工作薄（Workbook）中工作表（Sheet）的个数
           Sheet rs=rwb.getSheet(0);
           int l=rs.getColumns();             //返回表中的总列数
           int w=rs.getRows();               //返回表中包含总行数
           System.out.println("文件总共"+w+"行");
           Element root=new Element("allmetadata");
           Document doc=new Document(root);
           for(int i=0;i<w;i++)
           {
        Cell[] cell = rs.getRow(i);
        //System.out.println(cell.length);

        Element instrument=new Element("metadata");
       
        Element e0=new Element("DBOperation");
        e0.setText("insert");
        instrument.addContent(e0);
       
        Element e1=new Element("EquipClassficationNum");
        e1.setText(cell[0].getContents());
        instrument.addContent(e1);
       
        Element e2=new Element("EuipNum");
        //e2.setText(rs.getString());
        e2.setText("null");
        instrument.addContent(e2);
       
        Element e3=new Element("EquipCHNName");
        e3.setText(cell[1].getContents());
        //e3.setText("null");
        instrument.addContent(e3);
       
        Element e4=new Element("EquipENGName");
        //e3.setText(rs.getString(2));
        e4.setText("null");
        instrument.addContent(e4);
       
        Element e5=new Element("EquipModel");
        e5.setText(cell[2].getContents());
        //e5.setText("null");
        instrument.addContent(e5);
       
        Element e6=new Element("EquipTechParameter");
        e6.setText(cell[3].getContents());
        //e5.setText("null");
        instrument.addContent(e6);
       
        Element e7=new Element("EquipApplicationArea");
        e7.setText(cell[4].getContents());
        //e7.setText("null");
        instrument.addContent(e7);
       

       
        Element e8=new Element("EquipAccessory");
        //e8.setText(rs.getString(5));
        e8.setText("null");
        instrument.addContent(e8);
       
        Element e9=new Element("EquipCertification");
        e9.setText(cell[5].getContents());
        //e9.setText("null");
        instrument.addContent(e9);

       
        Element e10=new Element("EquipManufacturer");
        e10.setText(cell[6].getContents());
        //e9.setText("null");
        instrument.addContent(e10);
       
        Element e11=new Element("EquipManuCountryCode");
        e11.setText(cell[7].getContents());
        //e11.setText("null");
        instrument.addContent(e11);
       
        Element e12=new Element("EquipPriceRMB");
        e12.setText(cell[8].getContents());
        //System.out.println(cell[8].getContents());
        //e11.setText("null");
        instrument.addContent(e12);
       
        Element e13=new Element("EquipServiceDate");
        e13.setText(cell[9].getContents());
        //e11.setText("null");
        instrument.addContent(e13);
       
        Element e14=new Element("Equip");
        e14.setText(cell[10].getContents());
        //e11.setText("null");
        instrument.addContent(e14);
       
        Element e15=new Element("EquipLocation");
        e15.setText(cell[11].getContents());
        //e11.setText("null");
        instrument.addContent(e15);
       
        Element e16=new Element("EquipZIPCode");
        e16.setText(cell[12].getContents());
        //e11.setText("null");
        instrument.addContent(e16);
       
        Element e17=new Element("EquipContactPerson");
        e17.setText(cell[13].getContents());
        //e11.setText("null");
        instrument.addContent(e17);
       
        Element e18=new Element("EquipTelephone");
        e18.setText(cell[14].getContents());
        System.out.println(cell[14].getContents());
        //e11.setText("null");
        instrument.addContent(e18);
       
        Element e19=new Element("EquipEmail");
        //e19.setText(rs.getString(15));
        e19.setText("null");
        instrument.addContent(e19);
       
        Element e20=new Element("EquipOpenCalendar");
        e20.setText(cell[15].getContents());
        //e20.setText("null");
        instrument.addContent(e20);
       
        Element e21=new Element("EquipServiceCharge");
        e21.setText(cell[16].getContents());
        //e11.setText("null");
        instrument.addContent(e21);
       
        Element e22=new Element("EquipTotalServiceTime");
        //e22.setText(rs.getString(16));
        e22.setText("null");
        instrument.addContent(e22);
       
        Element e23=new Element("EquipTotalServiceFee");
        //e22.setText(rs.getString(16));
        e23.setText("null");
        instrument.addContent(e23);
       
        Element e24=new Element("EquipServiceUsers");
        //e22.setText(rs.getString(16));
        e24.setText("null");
        instrument.addContent(e24);
       
        Element e25=new Element("EquipServiceAchivements");
        //e22.setText(rs.getString(16));
        e25.setText("null");
        instrument.addContent(e25);
       
        Element e26=new Element("EquipOtherInfo");
        //e22.setText(rs.getString(16));
        e26.setText("null");
        instrument.addContent(e26);
       
        root.addContent(instrument);
        //System.out.println("第"+i+"行生成完成！");
              
           }
        XMLOutputter outputter=new XMLOutputter();
        FileOutputStream output=new FileOutputStream("ningxia.xml");
        outputter.output(doc,output);
          
           rwb.close();
           is.close();
           outputter.clone();
          
          
          
          
          
           //String strc00=c00.getContents();
          // System.out.println(strc00);
          
           //System.out.println(rs.getName());
           //System.out.println();   //返回表中的总列数
           //System.out.println();        //返回表中包含总行数
        }catch(Exception e)
        {
          e.printStackTrace();
        }
    }
   
}