<%@ page language="java" contentType="application/vnd.ms-excel; text/html; charset=euc-kr"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix= "fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
response.setHeader("Content-Disposition", "attachment; filename=test_excel.xls");
response.setHeader("Content-Description", "JSP Generated Data");
response.setContentType("application/vnd.ms-excel");
%>
<jsp:scriptlet>pageContext.setAttribute("newline", "\n");</jsp:scriptlet>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>test_excel</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<style type="text/css">
.head{background-color: #F0E9D9}
/*
td{font-size:9pt; font-family:굴림;mso-number-format:"\@";mso-text-control:shrinktofit;white-space:nowrap;}
*/
td{text-align: center; font-size:9pt; font-family:굴림;mso-number-format:"\@";}
br{mso-data-placement:same-cell;}
</style>
</head>
<body>
<table border="1">
<tr class="head">
<th>순번</th>
<th>일련번호</th>
<th>연락처</th>
<th>내용</th>
<th>진행상태</th>
<th>비고</th>
</tr>
<c:forEach items="${ResultList }" var="item">
<tr>
<td style="width: 45px;">${item.RUM }</td>
<td style="width: 75px;">${item.IDX }</td>
<td style="width: 85px;">
<c:out value="${fn:substring(item.REGIDATE, 0, 4)}" />-<c:out value="${fn:substring(item.REGIDATE, 4, 6)}" />-<c:out value="${fn:substring(item.REGIDATE, 6, 8)}" />
</td>
<td>${item.CONTACT }</td>
<td style="text-align: left; padding-left: 5px;">${fn:replace(fn:escapeXml(item.CONTENT),newline ,'<br>') }</td>
<td style="width: 70px;">
<c:choose>
<c:when test="${item.STATE eq '1' }">접수</c:when>
<c:when test="${item.STATE eq '9' }">완료</c:when>
</c:choose>
</td>
<td>${item.OTHER }</td>
</tr>
</c:forEach>
</table>
</body>
</html>