java中生成Excel表的封装类

将poi包放到WEB-INF/bin下，然后调用outExcel方法就行了；

 

 

package com.mycompany.helper.common.service;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class CreateExcelService {
 
 /**
  * 输出excel表
  * infos 数据源，sheetName 表名
  */
 public static void outExcel(HttpServletResponse response,String[][] infos,
   String sheetName) {
  try {
   // 清空输出流
   response.reset();
   //设置输出字符集
   response.setCharacterEncoding("utf-8");
   //定义输出类型
   response.setHeader("Content-disposition",
     "attachment; filename="+new String(sheetName.getBytes("GBK"), "ISO-8859-1")+".xls");//设定输出文件头
   response.setContentType("application/msexcel");
   //实例化工作类
   HSSFWorkbook workbook = new HSSFWorkbook();
   //创建一张表
   HSSFSheet sheet = workbook.createSheet();
   //默认的列的宽度
   sheet.setDefaultColumnWidth((short)20);
   //设置第一张表的名字
   workbook.setSheetName(0, sheetName);
   
   //添加表的内容
   for (int i = 0; i < infos.length; i++) {
    //创建新行
    HSSFRow xslRow = sheet.createRow(i);
    addRow(xslRow, infos[i]);
   }
   //输出
   workbook.write(response.getOutputStream());
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 
 /**
  * 添加行
  */
 private static void addRow(HSSFRow xslRow, String[] rows){
  for(int i=0;i<rows.length;i++){
   //添加单元格
   HSSFCell cell = xslRow.createCell((short) i);
   String text = rows[i];
   
   //解决在web工程下的中文乱码问题
   cell.setEncoding(HSSFCell.ENCODING_UTF_16);
   cell.setCellValue(text);
  }
 }
}