java excel匯出

標籤：excel

看了下同事寫的匯出excel 很簡單   記下來備用

     1、加入必須的jar包 poi-3.10-FINAL-20140208.jar 

     2、建立檔案名稱 “XXXX.xlsx” 

     3、Workbook wb = null;

     4、Workbook wb = new XSSFWorkbook();

     5、Sheet sheet = wb.createSheet(fileName);

     6、String[] title = {"合約編號"}

     7、Row titleRow = sheet.createRow(0);

     8、初始化表頭  

       private void initialiseRow(Row row,String[] title){
for (int i = 0; i < title.length; i++) {
Cell cell = row.createCell(i);
cell.setCellValue(title[i]);
}
}

    9、填充資料

     for (int i = 0; i < list.size(); i++) {
Row row = sheet.createRow(i+1);
row.createCell((short) 0).setCellValue(list.get(i).getCode());

         }

  10、響應請求

     OutputStream os = null;  
        try {
            os = new BufferedOutputStream(response.getOutputStream());// 取得輸出資料流  
            response.reset();// 清空輸出資料流 
            response.addHeader("Content-disposition","attachment;filename=" 
            + new String( fileName.getBytes("gbk"), "ISO8859-1" ));
            response.setContentType("application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");
            wb.write(os);
            os.flush();
            os.close();
        } catch (IOException e) {
        logger.error("匯出購保情況的Excel出錯: ", e);
        }

java excel匯出