[JSP] excel 내보내기시 표시형식 지정하기

 

<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\]\-\#\,\#\#0\.00\ "	2 decimals, negative numbers in red and signed (1.56 -1.56)

 

 

 <참고> 엑셀 다운로드용 jsp 선언

<%@ 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");

%>