從數據庫導出數據到excel之List>導出

List<List<String>> order=export.ExportOrderTestService(channel, status, startime, endtime, empId);//這裏是個人查詢數據，能夠更改
        System.out.println(order);
        String[] headers=export.ListHeaderName(channelId);
        for (String string : headers) {
            System.out.println(string);
        }
        String fieldName=channel+"表";
        ExportExcelOutputStream ee=new ExportExcelOutputStream();
        ee.exportExcel(order, headers, fieldName, response);

public class ExportExcelOutputStream {
     public String exportExcel(List<List<String>> order,String[] headerlist, 
             String name,HttpServletResponse response ) {  
            String result = "系統提示：Excel文件導出成功！";  
            // 如下開始輸出到EXCEL  
            try {  
                 //定義輸出流，以便打開保存對話框______________________begin  
                 OutputStream os = response.getOutputStream();// 取得輸出流  
                 response.reset();// 清空輸出流                     
                 String fileName = name + ".xls";  
                 response.setContentType("application/x-msdownload");// 設定輸出文件類型
                 response.setHeader("Content-Disposition",
                         "attachment;filename=" + new String( fileName.getBytes("gb2312"), "ISO8859-1" )); //設定文件輸出頭         
                 //定義輸出流，以便打開保存對話框_______________________end  
                /** **********建立工做簿************ */  
                WritableWorkbook workbook = Workbook.createWorkbook(os);        
                /** **********建立工做表************ */       
                WritableSheet sheet = workbook.createSheet("Sheet1", 0);        
                /** **********設置縱橫打印（默認爲縱打）、打印紙***************** */  
                SheetSettings sheetset = sheet.getSettings();  
                sheetset.setProtected(false);  
                sheetset.setDefaultColumnWidth(20); 
                /** ************設置單元格字體************** */  
                WritableFont NormalFont = new WritableFont(WritableFont.ARIAL, 10);  
                WritableFont BoldFont = new WritableFont(WritableFont.ARIAL, 10,  
                        WritableFont.BOLD);  
                WritableFont TitleFont = new WritableFont(WritableFont.ARIAL, 20,  
                        WritableFont.BOLD);        
                /** ************如下設置三種單元格樣式，靈活備用************ */  
                // 用於表名
                WritableCellFormat title_center = new WritableCellFormat(TitleFont);  
                title_center.setBorder(Border.ALL, BorderLineStyle.THIN); // 線條  
                title_center.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直對齊  
                title_center.setAlignment(Alignment.CENTRE); // 文字水平對齊  
                title_center.setWrap(false); // 文字是否換行  
                  
                // 用於標題居中  
                WritableCellFormat wcf_center = new WritableCellFormat(BoldFont);  
                wcf_center.setBorder(Border.ALL, BorderLineStyle.THIN); // 線條  
                wcf_center.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直對齊  
                wcf_center.setAlignment(Alignment.CENTRE); // 文字水平對齊  
                wcf_center.setWrap(false); // 文字是否換行  
      
                // 用於正文居左  
                WritableCellFormat wcf_left = new WritableCellFormat(NormalFont);  
                wcf_left.setBorder(Border.NONE, BorderLineStyle.THIN); // 線條  
                wcf_left.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直對齊  
                wcf_left.setAlignment(Alignment.LEFT); // 文字水平對齊  
                wcf_left.setWrap(true); // 文字是否換行                
                /** ***************如下是EXCEL第一行列標題********************* */  
                for (int i = 0; i < headerlist.length; i++) {  
                    System.out.println(headerlist[i]);
                    sheet.addCell(new Label(i, 0, headerlist[i], wcf_center));  
                }  
                /** ***************如下是EXCEL正文數據********************* */  
                int i = 1;  
                for (List<String> orderlist : order) {                                 
                    int j = 0;  
                    System.out.println(orderlist);
                    for (Object obj : orderlist) {
                        System.out.println(obj);
                        sheet.addCell(new Label(j, i, obj.toString(), wcf_left));//j表示列，i表示行，va.toString是數據，wcf_left是樣式
                        j++;                               
                }  
                i++;  
                }
                /** **********將以上緩存中的內容寫到EXCEL文件中******** */  
                workbook.write();  
                /** *********關閉文件************* */  
                workbook.close();  
                  
                System.out.println(result);  
            
            } catch (Exception e) {  
                result = "系統提示：Excel文件導出失敗，緣由：" + e.toString();  
                System.out.println(result);  
                e.printStackTrace();  
            }  
            return result;  
        }  
}