jsp 导出excel

设置头文件

<%
response.setHeader( "Pragma ", "public");
response.setHeader( "Cache-Control ", "must-revalidate, post-check=0, pre-check=0 ");
response.addHeader( "Cache-Control ", "public ");
response.addHeader("Content-Disposition", "attachment; filename=posStatistic_export.xls");
response.setContentType("application/vnd.ms-excel.numberformat:@;charset=UTF-8");
%>

 

如果还有乱码

 

<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">