Use JSP to export as excel

最新推荐文章于 2023-11-14 11:54:09 发布

Paulmin

最新推荐文章于 2023-11-14 11:54:09 发布

阅读量1.1k

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/Paulmin/article/details/14643503

版权

Java 专栏收录该内容

34 篇文章 0 订阅

订阅专栏

Purely JSP without any addtional excel API. Simple but lack of funtional excel control.

Look below codes

<%
	String fileName=(String)request.getAttribute("fileName");
	fileName = new String(fileName.getBytes("GBK"), "iso-8859-1");
	response.reset();
	response.setContentType("application/vnd.ms-excel;charset=GBK");
	response.addHeader("Content-Disposition","attachment; filename=" + fileName);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk"/>
</head>
<body>
	<table width="100%" border="1" align="right" cellpadding="0" cellspacing="1">
		<thead>
			<tr>
				<th>序号</th>
				<th>编码</th>
				<th>时间</th>
			</tr>
		</thead>
		<tbody>
		<c:forEach var="entity" items="${pageBean.dataList}" varStatus="s">
			<tr>
				<td><c:out value="${s.index+1}"/></td>
				<td><c:out value="${entity.code}"/></td>
				<td><fmt:formatDate value="${entity.returnDate}" pattern="yyyy-MM-dd HH:mm:ss" /></td>
			</tr>
		</c:forEach>
		</tbody>
	</table>
</body>
</html>

问题：

1. 如果输出为 1000000001，浏览器导出时会转换为科学计数法，变为：1E+10。不好看。

解决办法： <td style='vnd.ms-excel.numberformat:@'><c:out value="${orderDetail.purchaseOrder.outsideNo}"/></td>

特殊数字格式：<fmt:formatNumber value="${businessOrderDetail.quantity*businessOrderDetail.goodsSalesPrice}" type="number" pattern="#,##0.00" />

有comma不会有此问题

Paulmin

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Use JSP to export as excel

Purely JSP without any addtional excel API. Simple but lack of funtional excel control.Look below codes<% String fileName=(String)request.getAttribute("fileName"); fileName = new String(fileNa
复制链接

扫一扫