/**导出excel
*
*
* @param list 要显示的集合
* @param cellName 要显示的列头
* @param valueNames 要显示的列
* @param fileName 文件名称
*/
public static void exportUtils(List<Map<String,Object>> list,String[] cellName,String [] valueNames,String fileName,HttpServletResponse response){
// 创建excel工作簿
Workbook wb = new HSSFWorkbook();
// 创建第一个sheet(页),并命名
Sheet sheet = wb.createSheet(fileName);
// 创建第一行
Row row = sheet.createRow((short) 0);
Cell cell=null;
if(cellName.length>0){
for(int i=0;i<cellName.length;i++){
cell = row.createCell(i);
cell.setCellValue(cellName[i]);
}
}
for (short i = 0; i < list.size(); i++) {
Map<String,Object> map=list.get(i);
row = sheet.createRow((short) i + 1);
for(int j=0;j<valueNames.length;j++){
cell = row.createCell(j);
cell.setCellValue((map.get(valueNames[j])!=null?map.get(valueNames[j]).toString():" "));
}
}
try {
response.reset();
response.setContentType("application/vnd.ms-excel;charset=utf-8");
response.setHeader("Content-Disposition", "attachment;filename="+new String((fileName+".xls").getBytes(),"iso-8859-1"));
wb.write(response.getOutputStream());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
使用POI导出excel
最新推荐文章于 2023-06-14 09:41:37 发布