利用poi导出excel的工具种

利用poi导出excel的工具类
在实际的项目中，经常会有导出到Excel的功能，前阶段研究了下poi导出Excel，自己整理了一个导出的工具类，下面把代码贴出来，大家相互学习学习！

工具类

import java.io.OutputStream;import java.net.URLEncoder;import javax.servlet.http.HttpServletResponse;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;/** * 导出Excel工具类 * @author goodboyloveyy * */public abstract class ExcelUtils {/** * 生成excel的通用模版 * @param response *            响应,设置生成的文件类型,文件头编码方式和文件名,以及输出 * @param firstLine *            标题字符串数组 String[] * @param sheetName *            工作表名 * @param fileName *            文件名 */@SuppressWarnings("deprecation")public void excel(HttpServletResponse response, String[] firstLine,String sheetName, String fileName) throws Exception{HSSFWorkbook wb = new HSSFWorkbook();// excel文件,一个excel文件包含多个表HSSFSheet sheet = wb.createSheet();// 表，一个表包含多个行wb.setSheetName(0, sheetName, HSSFWorkbook.ENCODING_UTF_16);  //设置sheet中文编码// 设置字体等样式HSSFFont font = wb.createFont();font.setFontHeightInPoints((short) 12);font.setFontName("Courier New");HSSFCellStyle style = wb.createCellStyle();style.setFont(font);style.setWrapText(true);style.setAlignment(HSSFCellStyle.ALIGN_LEFT);style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);HSSFRow row;// 行，一行包括多个单元格HSSFCell cell;// 单元格row = sheet.createRow(0);//由HSSFSheet生成行row.setHeightInPoints((float) 15);//设置行高// 生成首行标题for (short j = 0; j < firstLine.length; j++) {cell = row.createCell(j);//由行生成单元格cell.setCellStyle(style);//设置单元格样式cell.setEncoding(HSSFCell.ENCODING_UTF_16);//设置cell中文编码；cell.setCellValue(firstLine[j]);sheet.setColumnWidth(j, (short) (5000));//设置列宽}fillData(sheet, style);// 该方法由具体调用时进行实现// 导出OutputStream out = null;response.setContentType("application/x-msdownload");// 设置生成的文件类型response.setHeader("Content-Disposition", "attachment;filename="+ URLEncoder.encode(fileName, "UTF-8"));out = response.getOutputStream();//取得输出流wb.write(out);//写入Excelout.close();}/** * 该方法由生成具体的表格时去实现(方法体内进行填充数据) *  * @param sheet * @param style */public abstract void fillData(HSSFSheet sheet, HSSFCellStyle style);}

public String exportCardTypeList(){User user = (User) ActionContext.getContext().getSession().get("user");if(user==null){return LOGIN;}else{String[] cloumnName = {"卡类型编号","卡类型名称"};  //导出的列名    String sheetName = "产品信息";   //sheet的名称    String fileName = "cardTypelist.xls";   //文件名    HttpServletResponse response = ServletActionContext.getResponse();    try {    cardTypeList = cardManageService.loadCardType();//查询出数据ExcelUtils excelUtil = new ExcelUtils(){  //生成工具类实例，并实现填充数据的抽象方法@SuppressWarnings("deprecation")@Overridepublic void fillData(HSSFSheet sheet, HSSFCellStyle style) {SSFRow row;//行，一行包括多个单元格HSSFCell cell;//单元格if (null != cardTypeList || cardTypeList.size() > 0) { for (int k = 0; k < cardTypeList.size(); k++) { row = sheet.createRow(k+1); row.setHeightInPoints((float) 15);                        CardType cardType = cardTypeList.get(k);                    cell = row.createCell((short)0);                         cell.setCellStyle(style);                         cell.setEncoding(HSSFCell.ENCODING_UTF_16);                         cell.setCellValue(SystemUtil.isNull(String.valueOf(cardType.getTypeId())));//产品编号                                                                           cell = row.createCell((short)1);                         cell.setCellStyle(style);                         cell.setEncoding(HSSFCell.ENCODING_UTF_16);                         cell.setCellValue(SystemUtil.isNull(cardType.getName()));//产品名称                                     }        }    }};excelUtil.excel(response, cloumnName, sheetName, fileName);return null;} catch (Exception e) {logger.error("exportCardTypeList error!", e);return ERROR;}    }}