有时候我门需要把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();
}
}
}