백엔드개발/자바스프링

앱)java spring framework excel export jstl

HULIA(휴리아) 2018. 6. 11. 18:15




<a href="#" class="com_s_excel" onclick="exportExcel();"><span>Export to Excel</span></a>

function exportExcel(){
        $("searchForm").attr("action","<c:url value='/exportExcel.do' />").submit();
}

@RequestMapping(value="/exportExcel", method= RequestMethod.POST)
public ModelAndView exportExcel(HttpServletRequest request, HttpServletResponse response, @ModelAttribute SearchVo searchVo){
        ModelAndView view = new ModelAndView();
        
         view.addObject("contents", ServiceObj.getExportExcel(searchVo);
          view.setViewName("/exportExcel");

        return view;
}




====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" %>

<%
       response.setHeader("Content-Type", "application/vnd.ms-xls");
       response.setHeader("Content-Disposition", "inline; filename=ExportList.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>
          </head>
<body>
         <table style="text-align:center; font-weight:normal; background:#fafafa; color:#333; font-size:12px; border:1px solid #CCC;">
           <caption class="hide-caption">List</caption>
           <thead>
                  <tr style="border:1px solid #CCC; color:#555">
                          <th scope="col"><span class="sort" id="id">ID</span></th>
                           <th scope="col"><span class="sort" id="id">ID</span></th>
                    </tr>
              </thead>
              <tbody>
                      <c:choose>
                               <c:when test="${null != contents && !empty contents}">
                      <c:forEach var="contents" items="${contents}" varStatus="lineIndex">
                           <tr style="padding:8px; line-height:16px; border:1px solid #CCC; color:#555; font-size:12px; vertical-align:middle; word-break:break-all;">
                              <td class="al_c">${contents.code}</td>
<td class="al_c">${contents.name}</td>
<td class="al_c">${contents.desc}</td>
<td class="al_c">${contents.code1}</td>
<td class="al_c">${contents.code2}</td>
<td class="al_c">${contents.code2}</td>
                                  <tr>
                               </c:forEach>
                           </c:when>
                       <c:otherwise>
                       </c:otherwise>
                     </c:choose>
                   </tbody>
                 </table>
            </body>
         </html>