JSP导出Excel表格文件名+内容乱码解决+网格显示

来源：互联网发布：广州用友软件代理商编辑：程序博客网时间：2024/06/02 17:09

【转载请注明出处:http://blog.csdn.net/leytton/article/details/38613549】

文件名乱码解决：

excelName=new String("学生信息统计".getBytes("GBK"), "ISO8859-1");

内容乱码解决：

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>

response.setContentType("application/vnd.ms-excel;charset=GBK");

<meta http-equiv="Content-Type" content="text/html; charset=GBK">

网格显示：

<html xmlns:x="urn:schemas-microsoft-com:office:excel">

<!-- 显示网格线 --><!--[if gte mso 9]><xml>            <x:ExcelWorkbook>                <x:ExcelWorksheets>                    <x:ExcelWorksheet>                        <x:Name>工作表标题</x:Name>                        <x:WorksheetOptions>                            <x:Print>                                <x:ValidPrinterInfo />                            </x:Print>                        </x:WorksheetOptions>                    </x:ExcelWorksheet>                </x:ExcelWorksheets>            </x:ExcelWorkbook>        </xml>        <![endif]--><!-- 显示网格线 -->

全部代码：

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";   excelName=new String("学生信息统计".getBytes("GBK"), "ISO8859-1");   response.reset();   response.setHeader("Pragma", "No-cache");    response.setHeader("Cache-Control", "No-cache");    response.setDateHeader("Expires", 0);     response.setContentType("application/vnd.ms-excel;charset=GBK");   response.setHeader("Content-disposition", "inline;filename="+excelName+".xls");%><html xmlns:x="urn:schemas-microsoft-com:office:excel"><head><!-- 显示网格线 --><!--[if gte mso 9]><xml>            <x:ExcelWorkbook>                <x:ExcelWorksheets>                    <x:ExcelWorksheet>                        <x:Name>工作表标题</x:Name>                        <x:WorksheetOptions>                            <x:Print>                                <x:ValidPrinterInfo />                            </x:Print>                        </x:WorksheetOptions>                    </x:ExcelWorksheet>                </x:ExcelWorksheets>            </x:ExcelWorkbook>        </xml>        <![endif]--><!-- 显示网格线 --><meta http-equiv="Content-Type" content="text/html; charset=GBK"></head><body><table><tr>  <td>学号</td>  <td>姓名</td>  <td>年龄</td></tr><tr> <td>121310</td>  <td>张三</td>  <td>18</td> </tr> <tr>  <td>121311</td>  <td>李四</td>  <td>19</td> </tr> <tr>  <td>121312</td>  <td>王五</td>  <td>20</td> </tr></table>    </body> </html>

1 0

JSP导出Excel表格 文件名+内容乱码解决+网格显示

JSP导出Excel表格文件名+内容乱码解决+网格显示