앱)jstl java jsp excel export
exportexcel.jsp
<% page language="java" contentType="application/vnd.ms-excel; charset=utf-8" pageEncoding="utf-8"%>
<% taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<% taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%
response.setHeader("Content-Type". "application/vnd.ms-xls");
response.setHeader("Content-Disposition", "inline; filename=xxxx.xls");
%>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html"; charset="utf-8" />
<style>td{mso-number-format:\@; } </style>
<body>
<table>
<thead>
<tr>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</body>
</html>
function exportExcel(){
$("#searchForm").attr("action", "<c:url value='/xx.do' />").submit();
}
<% page language="java" contentType="application/vnd.ms-excel; charset=utf-8" pageEncoding="utf-8"%>
<% taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<% taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%
response.setHeader("Content-Type". "application/vnd.ms-xls");
response.setHeader("Content-Disposition", "inline; filename=xxxx.xls");
%>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html"; charset="utf-8" />
<style>td{mso-number-format:\@; } </style>
<body>
<table>
<thead>
<tr>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
<th scope="col"><span></span></th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</body>
</html>
function exportExcel(){
$("#searchForm").attr("action", "<c:url value='/xx.do' />").submit();
}
'백엔드개발 > 자바스프링' 카테고리의 다른 글
| 앱)sqlSessionDao관련 (0) | 2018.11.14 |
|---|---|
| 앱)paging 관련 (0) | 2018.11.14 |
| 앱)java spring에서 web page간의 연동처리 (0) | 2018.11.14 |
| 앱)java spring application config properties 방식 (0) | 2018.11.14 |
| 앱)java spring application Config xml방식 (0) | 2018.11.14 |