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);