java

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import org.w3c.dom.DOMImplementation;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Text;
import com.sun.org.apache.xerces.internal.dom.DOMImplementationImpl;
import com.sun.org.apache.xml.internal.serialize.OutputFormat;
import com.sun.org.apache.xml.internal.serialize.XMLSerializer;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class Test {

 public static void main(String[] args) {
  int col = 0;
  int row = 0;
  ArrayList<String> list = new ArrayList<String>();
  DOMImplementation dom = DOMImplementationImpl.getDOMImplementation();
  Document docm = (Document) dom.createDocument(null, "students", null);
  docm.setXmlVersion("1.0");
  Element root = docm.getDocumentElement();
  docm.setXmlStandalone(true);
  try {
   Workbook book = Workbook.getWorkbook(new File("C://11.xls"));
   Sheet sheet = book.getSheet(0);
   col = sheet.getColumns();
   row = sheet.getRows();
   for (int i = 0; i < col; i++) {
    Cell cell = sheet.getCell(i, 0);
    list.add(cell.getContents());
   }
   
   for (int i = 1; i < row ; i++) {
    Element ele = docm.createElement("student");
    for (int j = 0; j < col ; j++) {
                    Element e = docm.createElement(list.get(j));
                    Text text = docm.createTextNode(sheet.getCell(j,i).getContents());
                    e.appendChild(text);
                    ele.appendChild(e);
    }
    root.appendChild(ele);
   }
   
   BufferedWriter wr = new BufferedWriter(new FileWriter("C://aa.xml"));
   
   OutputFormat format = new OutputFormat();
   format.setEncoding("gb2312");
   XMLSerializer serializer = new XMLSerializer(wr,format);
   serializer.serialize(docm);
   new InSert().Daoru();
  } catch (BiffException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  }
 }
}