[JS] 엑셀 다운로드 형식(내보내기 시 표형식 지정하기)

 

<td style='mso-number-format: "@";'>01034567890</td>

이렇게 지정하면 "010" 요런 문자도 "10"으로 표시되지 않고 "010"으로 잘 나온다

 

이런식으로 -->

<h3>회원 목록</h3>
 
    <table border="1">
        <thead>
            <tr>
                <th>ID</th>
                <th>이름</th>
                <th>전화번호</th>
            </tr>
        </thead>
         
        <tbody>
            <tr>
                <td>patriot2</td>
                <td>유관순</td>
                <td style='mso-number-format: "@";'>0431234567</td>
            </tr>
            <tr>
                <td>pitcher</td>
                <td>류현진</td>
                <td style='mso-number-format: "@";'>01034567890</td>
            </tr>
            <tr>
                <td>historian</td>
                <td>신채호</td>
                <td>001886123456</td>
            </tr>
        </tbody>
    </table>

 

 

 

다른 형식 참고하기

//Styling Excel cells with mso-number-format

mso-number-format:"0"	                         NO Decimals
mso-number-format:"0\.000"	                     3 Decimals
mso-number-format:"\#\,\#\#0\.000"	             Comma with 3 dec
mso-number-format:"mm\/dd\/yy"	                 Date7
mso-number-format:"mmmm\ d\,\ yyyy"	             Date9
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM"	     D -T AMPM
mso-number-format:"Short Date"	                 01/03/1998
mso-number-format:"Medium Date"	                 01-mar-98
mso-number-format:"d\-mmm\-yyyy"	             01-mar-1998
mso-number-format:"Short Time"	                 5:16
mso-number-format:"Medium Time"                  5:16 am
mso-number-format:"Long Time"	                 5:16:21:00
mso-number-format:"Percent"	                     Percent - two decimals
mso-number-format:"0%"	                         Percent - no decimals
mso-number-format:"0\.E+00"	                     Scientific Notation
mso-number-format:"\@"	                         Text
mso-number-format:"\#\ ???\/???"	             Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00"	 £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-	 2 decimals, negative numbers in red and signed
\#\,\#\#0\.00\ "                                 (1.56 -1.56)

 

 

<엑셀 다운로드 선언>

<%@ page language="java" contentType="application/vnd.ms-excel; name='excel', text/html; 
	charset=UTF-8" pageEncoding="UTF-8"%>
<% 
    response.setHeader("Content-Disposition", "attachment; filename=diary.xls"); 
    response.setHeader("Content-Description", "JSP Generated Data"); 
    response.setContentType("application/vnd.ms-excel");
%>

 

 

 

 

.

.

.

 

블로그 참고 ->

https://androphil.tistory.com/442