Excel转换为Xml.doc

import java.awt.*;import java.io.*;import java.util.*;import java.awt.event.*;import javax.swing.*;import javax.swing.table.AbstractTableModel;import org.apache.poi.hssf.usermodel.*;import org.apache.poi.poifs.filesystem.POIFSFileSystem;import org.jdom.*;import org.jdom.input.*;import org.jdom.output.XMLOutputter;import org.jdom.xpath.XPath;public class ExcelToXml extends JFrame Container c;AbstractTableModel tm;Vector v1 = new Vector();JTable jt;String title = ;static String r2;ExcelToXml() setSize(800, 500);setTitle(EXCEL转XML系统);c = getContentPane();JMenuBar jb = new JMenuBar();JMenu jm = new JMenu(文件);JMenuItem ji1 = new JMenuItem(导入EXCEL);JMenuItem ji2 = new JMenuItem(导出XML);ji1.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) POIFSFileSystem fs1 = null;HSSFWorkbook wb1 = null;String r1;String ss = ;JFileChooser jc = new JFileChooser();int result = jc.showOpenDialog(ExcelToXml.this);File f1 = jc.getSelectedFile();if (result = JFileChooser.APPROVE_OPTION) try fs1 = new POIFSFileSystem(new FileInputStream(f1.toString();wb1 = new HSSFWorkbook(fs1); catch (IOException e1) e1.printStackTrace();HSSFSheet sheet = wb1.getSheetAt(0);HSSFRow row = sheet.getRow(0);title = new Stringrow.getLastCellNum();r2 = new Stringsheet.getLastRowNum();for (int i = 0; i row.getLastCellNum(); i+) HSSFCell cell = row.getCell(short) i);titlei = cell.getStringCellValue();v1.removeAllElements();tm.fireTableStructureChanged();for (int i = 1; i sheet.getLastRowNum(); i+) HSSFRow row1 = sheet.getRow(i);Vector rec_vector = new Vector();/ r2 = new Stringsheet.getLastRowNum();r2i = ROW;for (int j = 0; j ;System.out.println(r2i);tm.fireTableStructureChanged(););ji2.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) String ss = ;String s = + ;String s2 = ;for (int i = 1; i r2.length; i+) ss = ss + r2i;System.out.println(ss);String sss = s + ss + s2;Document xmldoc = null;SAXBuilder builder = new SAXBuilder();XMLOutputter outputter = new XMLOutputter();/ Element root;FileOutputStream fs;JFileChooser jc = new JFileChooser();int result = jc.showSaveDialog(ExcelToXml.this);File f1 = jc.getSelectedFile();if (result = JFileChooser.APPROVE_OPTION) try fs = new FileOutputStream(f1.toString();xmldoc = builder.build(new StringReader(sss);outputter.output(xmldoc, fs);fs.close(); catch (IOException e1) e1.printStackTrace(); catch (JDOMException e1) e1.printStackTrace(););jm.add(ji1);jm.add(ji2);jb.add(jm);setJMenuBar(jb);addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) System.exit(0););tm = new AbstractTableModel() public int getColumnCount() return title.length;/ 取得表格列数public int getRowCount() return v1.size();/ 取得表格行数public Object getValueAt(int row, int column) if (!v1.isEmpty()return (Vector) v1.elementAt(row).elementAt(column);elsereturn null;/ 取得单元格中的属性值public String getColumnName(int column) return titlecolumn;/ 设置表格列名public void setValueAt(Object value, int row, int column) / 数据模型不可编辑，该方法设置为空public Class getColumnClass(int c) return getValueAt(0, c).getClass();/ 取得列所属对象类public boolean isCellEditable(int row, int column) return false;/ 设置单元格不可编辑，为缺省实现;jt = n