Excel转换为Xml

《Excel转换为Xml》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、importjava.awt.*;importjava.io.*;importjava.util.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.table.AbstractTableModel;importorg.apache.poi.hssf.usermodel.*;importorg.apache.poi.poifs.filesystem.POIFSFileSystem;importorg.jdom.*;importorg.jdom.input.*;importorg.jdom.out

2、put.XMLOutputter;importorg.jdom.xpath.XPath;publicclassExcelToXmlextendsJFrame{Containerc;AbstractTableModeltm;Vectorv1=newVector();JTablejt;Stringtitle[]={};staticString[]r2;ExcelToXml(){setSize(800,500);setTitle("EXCEL转XML系统");c=getContentPane();JMenuBarjb=newJMenuBar();JMenujm=newJMe

3、nu("文件");JMenuItemji1=newJMenuItem("导入EXCEL");JMenuItemji2=newJMenuItem("导出XML");ji1.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){POIFSFileSystemfs1=null;HSSFWorkbookwb1=null;String[]r1;Stringss="";JFileChooserjc=newJFileChooser();intresult=jc.showOpenDi

4、alog(ExcelToXml.this);Filef1=jc.getSelectedFile();if(result==JFileChooser.APPROVE_OPTION){try{fs1=newPOIFSFileSystem(newFileInputStream(f1.toString()));wb1=newHSSFWorkbook(fs1);}catch(IOExceptione1){e1.printStackTrace();}HSSFSheetsheet=wb1.getSheetAt(0);HSSFRowrow=sheet.getRow(0);title=

5、newString[row.getLastCellNum()];r2=newString[sheet.getLastRowNum()];for(inti=0;i

6、et.getRow(i);Vectorrec_vector=newVector();//r2=newString[sheet.getLastRowNum()];r2[i]="

7、"+cell.getStringCellValue()+""";//System.out.println(r2[i]);}else{rec_vector.addElement(String.valueOf(cell.getNumericCellValue()));r2[i]=r2[i]+""+title[j]+"=""+(int)cell.getNumericCellValue()+""";}}else{rec_vector.addElement("");r2[i]=r2[i]+""+title[j]+"=""+""+""";}}v1.ad