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);
}
}
}
