Excel-生成工具类

package com.xxx.statistic.file; import java.io.FileOutputStream; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import java.util.Map; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.CellRangeAddress; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.IndexedColors; import com.hundsun.statistic.util.FileUtils; @SuppressWarnings("deprecation") public class ExcelWriter { public static void write(String floder ,String fileName,String title,String[] fields,String[] fieldNames,List<Map<String,Object>> records) throws Exception{ if (records.size()>0){ FileOutputStream fileOut = null; String filePath = "c:/statistic/excel/"+floder+"/"+fileName+"_" +new SimpleDateFormat("yyMMdd_HHmmss").format(new Date()) +".xls"; try { FileUtils.createFoldersByPath(filePath.substring(0,filePath.lastIndexOf("/"))); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(title); //报表标题行 0行 HSSFRow rowHead = sheet.createRow(0); rowHead.setHeightInPoints((short) 36);// 设置宽度 HSSFFont f = sheet.getWorkbook().createFont(); CellStyle style = sheet.getWorkbook().createCellStyle(); f.setFontHeightInPoints((short) 18);// 字号 f.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);// 加粗 f.setFontName("华文楷体"); style.setFont(f); style.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 左右居中 style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 上下居中 sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, fields.length-1));// 合并第一行单元格 HSSFCell cellHead = rowHead.createCell(0); cellHead.setCellValue(title); cellHead.setCellStyle(style); //表头 1行 HSSFRow rowTableHead = sheet.createRow(1); for(int i=0;i<fields.length;i++){ sheet.setColumnWidth(i, 5000); HSSFCell cell = rowTableHead.createCell(i); cell.setCellValue(fieldNames[i]); CellStyle styleTableHead = sheet.getWorkbook().createCellStyle(); styleTableHead.setFillForegroundColor(IndexedColors.AQUA.getIndex()); styleTableHead.setFillPattern(CellStyle.SOLID_FOREGROUND); styleTableHead.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 左右居中 styleTableHead.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 上下居中 styleTableHead.setBorderBottom(HSSFCellStyle.BORDER_THIN); //下边框 styleTableHead.setBorderLeft(HSSFCellStyle.BORDER_THIN);//左边框 styleTableHead.setBorderTop(HSSFCellStyle.BORDER_THIN);//上边框 styleTableHead.setBorderRight(HSSFCellStyle.BORDER_THIN);//右边框 cell.setCellStyle(styleTableHead); } //表体 2行开始 for(int i=0;i<records.size();i++){ HSSFRow rowTableBody = sheet.createRow(i+2); for(int j=0;j<fields.length;j++){ HSSFCell cell = rowTableBody.createCell(j); cell.setCellValue(records.get(i).get("oracle".equals(floder)?fields[j].toUpperCase():fields[j]).toString()); } } fileOut = new FileOutputStream(filePath); wb.write(fileOut); } catch (Exception e) { throw new Exception(e); }finally{ if (fileOut != null) try {fileOut.close();} catch (IOException e) {} } } } }