注意:需要工具poi jar包
/**
* execl导出
* @param list 内容
* @param request 请求
* @param response 响应
*/
public static void exportExcelWorkbook(List<?> list,HttpServletRequest request, HttpServletResponse response){
OutputStream out =null;
try {
Workbook work = new HSSFWorkbook();
Sheet sheet = work.createSheet("sheet1");
//CellStyle cellStyle =work.createCellStyle();
//cellStyle .setFillForegroundColor(HSSFColor.AQUA.index);
//cellStyle.setFillBackgroundColor(HSSFColor.AQUA.index);
//cellStyle.setFillPattern(HSSFCellStyle.FINE_DOTS);
Row row = sheet.createRow(0);
//sheet.setDefaultColumnStyle(1, sheetStyle);
//先加载列名
for (int i = 0; i < HERDES.length; i++) {
Cell cell=row.createCell(i);
//cell.setCellStyle(cellStyle);
cell.setCellValue(HERDES[i]);
sheet.setColumnWidth(i, (30 * 110));
}
//new row 开始加载内容
for (int i = 0; i < list.size(); i++) {
row = sheet.createRow(i + 1);
Object veObj =list.get(i);
String[] arr = veObj.toString().split(","); //这里重写了toString(),更好的转换数组型
for (int k = 0; k < HERDES.length; k++) {
row.createCell(k).setCellValue(arr[k].substring(arr[k].indexOf("=") + 1).equals("null") ? " "
: arr[k].substring(arr[k].indexOf("=") + 1));
}
}
//LOGGER.info("============excel数据填充加载完成===========");
response.setHeader("Content-Disposition",
"attachment;filename=" + new String(filename.getBytes("utf-8"), "iso8859-1"));
response.setContentType("application/ynd.ms-excel;charset=UTF-8");
out = response.getOutputStream();
work.write(out);
} catch (Exception e) {
LOGGER.error(e.getMessage());
}finally {
try {
out.flush();
out.close();
// LOGGER.info("execl导出流关闭");
} catch (IOException e) {
LOGGER.error(e.getMessage());
}
}
}
execl导出
最新推荐文章于 2022-05-15 18:28:33 发布