[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");

%>

 

 

다른 카테고리의 글 목록

Dev. 웹/HTML.JSP 카테고리의 포스트를 톺아봅니다