最近碰到一个问题,在jsp页面导出excel的时候,只导出1行没有乱码,导出2行的时候,出现乱码,然后我就一列列的导出,在倒数第2列的时候出现乱码,网上各种找资料,都没有怎么解决我的问题 ,网上大部分都是解决jsp中文乱码的帖子,跟我这个还是有点差别的。后来发现,不知道谁写的代码,由于涉及到导出,有可能导出word 也有可能导出excel,以前的人在代码中判断了一下:
<%
if("word".equals(docType)){
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head>
<body>
<style>
<!--
.td_border1{
border-right:1 solid #000;
border-bottom:1 solid #000;
}
-->
</style>
<%
}
注:jsp导出excel,如果其他该设置的都设置了,还有乱码,记得添加:
<meta http-equiv="Content-Type" content="text/html;charset=gb2312"><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="org.apache.commons.codec.binary.Base64"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<%@ page import="java.net.URLEncoder"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ taglib prefix="limit" uri="http://www.yineng.com/limit"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib prefix="ev" uri="http://www.yineng.com/enumvalue" %>
<%
String path = request.getContextPath();
response.setContentType("application/vnd.ms-excel;charset=UTF-8");
String excelName = "学生学分达标情况";
//乱码解决,根据用户浏览器获得下载信息
String agent = (String)request.getHeader("USER-AGENT");
if(agent != null && agent.indexOf("MSIE") == -1){// FF
excelName = "=?UTF-8?B?" + (new String(Base64.encodeBase64(excelName.getBytes("UTF-8")))) + "?=";
response.setHeader("Content-Disposition", "attachment; filename=" + excelName + ".xls");
} else { // IE
excelName = new String(excelName.getBytes("GBK"), "ISO-8859-1");
response.setHeader("Content-Disposition", "attachment; filename=" + excelName+ ".xls");
}
%>
<html>
<head></head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<body>
<div>
<table class="tableMainStyle" border="1">
<thead>
<tr>
<th class="xh_align">序号</th>
<th >学号</th>
<th >姓名</th>
<th >行政班</th>
<th >组织机构</th>
<th >专业</th>
<th >年级</th>
<th >性别</th>
<th >民族</th>
<th >学生总学分</th>
<th >是否达标</th>
</tr>
</thead>
<tbody >
<c:choose>
<c:when test="${! empty list }">
<c:forEach var="entity" items="${list }" varStatus="obj">
<tr>
<td>${obj.index+1 }</td>
<td>${entity.stuNum }</td>
<td>${entity.infoName }</td>
<td>${entity.orgClassName}</td>
<td>${entity.orgmanName}</td>
<td>${entity.specialtyName}</td>
<td>${entity.grade}</td>
<td>${entity.sex}</td>
<td>${entity.nation}</td>
<td>${entity.totalCredit}</td>
<td><ev:changeValue enumIndex="${entity.isCompliance}" enumClassPath="com.yineng.base.enums.StandardStateEnum" /></td>
</tr>
</c:forEach>
</c:when>
<c:otherwise>
<tr>
<td colspan="11" align="center"><s:text name="nodata" /></td>
</tr>
</c:otherwise>
</c:choose>
</tbody>
</table>
</div>
</body>
</html>