通过xml的解析多数据源对文件进行导出成excel

package mutixmlout;

/** *//**
 * @author Alex
 * @msg 把列记录的xml转化为excel
 */
import java.awt.Color;
import java.io.*;
import java.util.List;
import java.util.Vector;

import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import org.dom4j.Document;

import jxl.*;
import jxl.write.*;
import jxl.write.biff.RowsExceededException;

public class XMLExcel ...{

    public void printxls() ...{
        WritableWorkbook book = null;
        String[] name = null;
        List collist = null;
        List datalist = null;
        List subcollist = null;
        List subrowlist = null;
        WritableSheet sheet = null;
        File folder = new File("D://excel");
        if (!folder.exists()) ...{
            folder.mkdir();
        }
        try ...{
            book = Workbook.createWorkbook(new File(folder + "/result.xls"));
        } catch (IOException e) ...{
            e.printStackTrace();
        }
        
        XlsOut dom4j = new XlsOut();
        try ...{
            String url = "D:/xml/selectdatainfo.xml";

            Document tdoc = dom4j.parse(url);
            name = dom4j.database(tdoc);

            Document cdoc = dom4j.parse(url);
            collist = dom4j.colList(cdoc);

            Document rdoc = dom4j.parse(url);
            datalist = dom4j.rowList(rdoc);

        } catch (Exception e) ...{
            System.out.println(e.getMessage());
        }

        //////////////////////////////////////////////////////////////////

        for (int i = 0; i < name.length; i++) ...{
            // 进行附值
            int page=i+1;
            sheet = book.createSheet(name[i], i);
            subcollist = (List) collist.get(i);
            subrowlist = (List) datalist.get(i);
//            try {
//                sheet.addCell(new Label(0, 0, (String) name[i]));
//            } catch (RowsExceededException e2) {
//                // TODO Auto-generated catch block
//                e2.printStackTrace();
//            } catch (WriteException e2) {
//                // TODO Auto-generated catch block
//                e2.printStackTrace();
//            }
            //列
            for (int j = 0; j < subcollist.size(); j++) ...{
                try ...{
                    sheet.addCell(new Label(j, 0, (String) subcollist.get(j)));
                } catch (RowsExceededException e1) ...{
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                } catch (WriteException e1) ...{
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
            }

            System.out.println("..................................");

            //行
            int m = 0, n = 1;
            for (int k = 0; k < subrowlist.size(); k++) ...{
                try ...{
                    sheet.addCell(new Label(m, n, (String) subrowlist.get(k)));
                    m++;
                    if (m % subcollist.size() == 0) ...{
                        m = 0;
                        n++;
                        continue;
                    }
                } catch (RowsExceededException e) ...{
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                } catch (WriteException e) ...{
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }

            }
            System.out.println("..................................");

        }
        try ...{
            book.write();
            book.close();
        } catch (WriteException e) ...{
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) ...{
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    ///////////////////////////////////////////////////////////////////////
  
    public static void main(String[] args) ...{
        XMLExcel xe = new XMLExcel();
        xe.printxls();
    }
}