web開發之匯出excel工具類

標籤：style   blog   java   檔案   os   2014   

web開發中，一個系統的普通需求也包括匯出excel，一般採用POI做統計報表匯出excel。

匯出excel工具類：

import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStream;import java.util.List;import java.util.Map;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRichTextString;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class ExportExcel {private ExportExcel() {super();}public static void exportExcel(List<Object> list, Map<Integer, Long> map,String[] titles) throws IOException {// 建立Excel文檔HSSFWorkbook hwb = new HSSFWorkbook();// sheet 對應一個工作頁HSSFSheet sheet = hwb.createSheet("exportReport");int colNum = titles.length;// 建立第一行HSSFRow firstrow = sheet.createRow(0);HSSFCell[] firstcell = new HSSFCell[colNum];for (int col = 0; col < colNum; col++) {firstcell[col] = firstrow.createCell(col);firstcell[col].setCellValue(new HSSFRichTextString(titles[col]));}// 插入記錄int rowNum = map.size();for (int i = 0; i < rowNum; i++) {// 從第二行開始HSSFRow row = sheet.createRow(i + 1);// 插入list中的欄位for (int col = 0; col < colNum - 2; col++) {HSSFCell cell = row.createCell(col);cell.setCellValue(list.get(col).toString());}// 插入月份或日期row.createCell(colNum - 2).setCellValue(i + 1);// 插入總量row.createCell(colNum - 1).setCellValue(map.get(i + 1));}String fileName = titles[1].substring(0, 2);if (colNum == 4) {fileName += list.get(0) + "_" + list.get(1) + "年_年度報表";} else if (colNum == 5) {fileName += list.get(0) + "_" + list.get(1) + "年" + list.get(2)+ "月_月度報表";}// 建立檔案輸出資料流，準備輸出試算表OutputStream out = new FileOutputStream("../webapps/UsedMallMinaServer/files/"+ fileName + ".xls");hwb.write(out);out.close();}}