exportexcel java_java导出excel

/**

* 导出excel

*/

@SuppressWarnings("deprecation")

@RequestMapping("exportExcel")

public void exportExcel(HttpServletResponse response){

//查询要导出的list

//List bean= ...service.queryList();

XSSFWorkbook xsf = new XSSFWorkbook();

XSSFSheet sheet = xsf.createSheet();

XSSFCellStyle style = xsf.createCellStyle();

// 填充

//style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

// 添加标题颜色

//style.setFillForegroundColor(HSSFColor.BLUE.index);

// 获取字体

XSSFFont font = xsf.createFont();

// 加粗

font.setBold(true);

// 把设置好的字体效果放进样式

style.setFont(font);

XSSFRow row = sheet.createRow(0);

//设置excel标题

String[] head = {"ID","名称","性别","创建时间"};

for (int i = 0; i < head.length; i++) {

row.createCell(i).setCellValue(head[i]);

row.getCell(i).setCellStyle(style);

}

SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

for (int i = 0; i < productList.size(); i++) {

XSSFRow rowTo = sheet.createRow(i+1);

rowTo.createCell(0).setCellValue(bean.get(i).getId());

rowTo.createCell(1).setCellValue(bean.get(i).getName());

rowTo.createCell(2).setCellValue(bean.get(i).getSex());

rowTo.createCell(3).setCellValue(bean.get(i).getCreateDate());

}

this.excelDownload(xsf, response);

}

/**

* 导出excel lht

*/

public static void excelDownload(XSSFWorkbook wirthExcelWB,HttpServletResponse response) {

OutputStream out = null;

try {

out = response.getOutputStream();

//让浏览器识别是什么类型的文件

response.reset(); // 重点突出

response.setContentType("application/x-msdownload;charset=UTF-8");

String file = new String("导出数据.xls".getBytes("utf-8"), "iso-8859-1");//导出数据为要导出的文件的名称

response.setContentType("application/octet-stream; charset=utf-8");

response.setHeader("Content-Disposition", "attachment; filename=\"" + file + "\"");

wirthExcelWB.write(out);

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

if( null != out){

try {

out.close();

out = null;

} catch (IOException e) {

e.printStackTrace();

}

}

}

}