<![CDATA[
<div><h1 style="margin: 0pt; color: rgb(200, 66, 5); font-family: verdana;">QnA</h1>
<p style="margin: 0pt; color: rgb(200, 66, 5); font-family: verdana;"> </p>
<table width="100%" class="MsoTableGrid" style="border: currentColor; border-image: none; border-collapse: collapse;" border="1" cellspacing="0" cellpadding="0">
<tbody><tr>
<td valign="top" style="padding: 0cm 5.4pt; border: 1pt solid black; border-image: none; background-color: transparent;">
<p style="margin: 0cm 0cm 0pt;">
<font color="#000000" face="맑은 고딕" size="2">사용언어 <font color="#e31600">
(칠해주세요) =></font> (<span style="background-color: rgb(154, 165, 234);">C#</span>,VB)</font></p></td>
</tr>
<tr>
<td valign="top" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(212, 208, 200) black black; padding: 0cm 5.4pt; background-color: transparent;">
<p style="margin: 0cm 0cm 0pt;">
<font color="#000000" face="맑은 고딕" size="2">사용툴 (VS) : 2013</font></p></td>
</tr>
<tr>
<td valign="top" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(212, 208, 200) black black; padding: 0cm 5.4pt; background-color: transparent;">
<p style="margin: 0cm 0cm 0pt;">
<font color="#000000" face="맑은 고딕" size="2">운영체제 (OS) : window</font></p></td>
</tr>
<tr>
<td valign="top" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(212, 208, 200) black black; padding: 0cm 5.4pt; background-color: transparent;">
<p style="margin: 0cm 0cm 0pt;">
<font color="#000000" face="맑은 고딕" size="2">상세언어<font color="#e31600">(칠해주세요.)
=></font> 1) ASP.NET, 2) <span style="background-color: rgb(154, 165, 234);">ASP.NET MVC</span>, 3) ASP.NET AJAX</font></p></td>
</tr>
</tbody></table><p><br></p><p><br></p></div><p>안녕하세요..</p><p>하나가 해결되면 하나가 문제가 생기네요.. ㅎ</p><p>엑셀 파일 다운받는거로 계속 고민하고 있습니다.</p><p><br></p><p>'엑셀' 버튼을 클릭하면 엑셀을 다운받도록 하는 기능을 작업중입니다.</p><p>다운로드 창 띄우는거 까진 했는데, 한글이 깨집니다.</p><p>Charset 에 "utf-8" 설정해뒀는데도 깨지는 이유가 뭘까요?</p><p>html 화면에서도 meta 태그에 charset=utr-8 로 설정해뒀습니다..</p><p><br></p><p style="text-align: center;"><img src="https://t1.daumcdn.net/cfile/cafe/2547194B570EFC350E" class="txc-image" width="887" style="clear: none; float: none;" border="0" vspace="1" hspace="1" exif="{}" data-filename="x.png" actualwidth="887" id="A_2547194B570EFC350EC64C"/></p><p><br></p><p><br></p><p><br></p><p>html</p><div class="colorscripter-code" style='color: rgb(1, 1, 1); overflow: auto; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important; position: relative !important;'><table class="colorscripter-code-table" style="margin: 0px; padding: 0px; border-radius: 4px; border: currentColor; border-image: none; background-color: rgb(250, 250, 250);" cellspacing="0" cellpadding="0"><tbody><tr><td style="padding: 6px; border-right-color: rgb(229, 229, 229); border-right-width: 2px; border-right-style: solid;"><div style='margin: 0px; padding: 0px; text-align: right; color: rgb(102, 102, 102); line-height: 130%; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important; -ms-word-break: normal;'><div style="line-height: 130%;">1</div><div style="line-height: 130%;">2</div><div style="line-height: 130%;">3</div><div style="line-height: 130%;">4</div><div style="line-height: 130%;">5</div></div></td><td style="padding: 6px 0px;"><div style='margin: 0px; padding: 0px; color: rgb(1, 1, 1); line-height: 130%; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important;'><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"><span style="color: rgb(1, 1, 1);"><</span><span style="color: rgb(6, 109, 226);">head</span><span style="color: rgb(1, 1, 1);">></span></div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> <span style="color: rgb(1, 1, 1);"><</span><span style="color: rgb(6, 109, 226);">meta</span> <span style="color: rgb(10, 153, 137);">name</span>=<span style="color: rgb(223, 80, 0);">"viewport"</span><span style="color: rgb(10, 153, 137);"></span> <span style="color: rgb(10, 153, 137);">http-equiv</span>=<span style="color: rgb(223, 80, 0);">"Content-Type"</span><span style="color: rgb(10, 153, 137);"></span> <span style="color: rgb(10, 153, 137);">content</span>=<span style="color: rgb(223, 80, 0);">"text/html; charset=utf-8"</span><span style="color: rgb(10, 153, 137);"></span> <span style="color: rgb(10, 153, 137);">/</span><span style="color: rgb(1, 1, 1);">></span></div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"><span style="color: rgb(1, 1, 1);"><</span><span style="color: rgb(1, 1, 1);">/</span><span style="color: rgb(6, 109, 226);">head</span><span style="color: rgb(1, 1, 1);">></span></div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> </div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"><span style="color: rgb(1, 1, 1);"><</span><span style="color: rgb(6, 109, 226);">input</span> <span style="color: rgb(10, 153, 137);">id</span>=<span style="color: rgb(223, 80, 0);">"btnExcel"</span><span style="color: rgb(10, 153, 137);"></span> <span style="color: rgb(10, 153, 137);">type</span>=<span style="color: rgb(223, 80, 0);">"button"</span><span style="color: rgb(10, 153, 137);"></span> <span style="color: rgb(10, 153, 137);">value</span>=<span style="color: rgb(223, 80, 0);">"엑셀"</span><span style="color: rgb(10, 153, 137);"></span> <span style="color: rgb(10, 153, 137);">/</span><span style="color: rgb(1, 1, 1);">></span></div></div><div style="text-align: right; font-size: 9px; font-style: italic; margin-top: -13px; margin-right: 5px;"><a style="color: rgb(229, 229, 229); text-decoration: none;" href="http://colorscripter.com/info#e" target="_blank">Colored by Color Scripter</a></div></td><td style="padding: 0px 2px 4px 0px; vertical-align: bottom;"><a style="color: white; text-decoration: none;" href="http://colorscripter.com/info#e" target="_blank"><span style="padding: 1px; border-radius: 10px; color: white; font-size: 9px; -ms-word-break: normal; background-color: rgb(229, 229, 229);">cs</span></a></td></tr></tbody></table></div><p><br></p><p> javascript</p><div class="colorscripter-code" style='color: rgb(1, 1, 1); overflow: auto; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important; position: relative !important;'><table class="colorscripter-code-table" style="margin: 0px; padding: 0px; border-radius: 4px; border: currentColor; border-image: none; background-color: rgb(250, 250, 250);" cellspacing="0" cellpadding="0"><tbody><tr><td style="padding: 6px; height: 61px; border-right-color: rgb(229, 229, 229); border-right-width: 2px; border-right-style: solid;"><div style='margin: 0px; padding: 0px; text-align: right; color: rgb(102, 102, 102); line-height: 130%; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important; -ms-word-break: normal;'><div style="line-height: 130%;">1</div><div style="line-height: 130%;">2</div><div style="line-height: 130%;">3</div></div></td><td style="padding: 6px 0px; height: 61px;"><div style='margin: 0px; padding: 0px; color: rgb(1, 1, 1); line-height: 130%; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important;'><div style="padding: 0px 6px; line-height: 130%; white-space: pre;">$(<span style="color: rgb(99, 163, 92);">"#btnExcel"</span>).click(<span style="color: rgb(167, 29, 93);">function</span>(){</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> <span style="color: rgb(6, 109, 226);">document</span>.<span style="color: rgb(6, 109, 226);">location</span> <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">=</span> <span style="color: rgb(99, 163, 92);">"/RegiAgent/ExportExcel"</span>;</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;">});</div></div><div style="text-align: right; font-size: 9px; font-style: italic; margin-top: -13px; margin-right: 5px;"><a style="color: rgb(229, 229, 229); text-decoration: none;" href="http://colorscripter.com/info#e" target="_blank">Colored by Color Scripter</a></div></td><td style="padding: 0px 2px 4px 0px; height: 61px; vertical-align: bottom;"><a style="color: white; text-decoration: none;" href="http://colorscripter.com/info#e" target="_blank"><span style="padding: 1px; border-radius: 10px; color: white; font-size: 9px; -ms-word-break: normal; background-color: rgb(229, 229, 229);">cs</span></a></td></tr></tbody></table></div><p><br></p><p>c#</p><div class="colorscripter-code" style='color: rgb(1, 1, 1); overflow: auto; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important; position: relative !important;'><table class="colorscripter-code-table" style="margin: 0px; padding: 0px; border-radius: 4px; border: currentColor; border-image: none; background-color: rgb(250, 250, 250);" cellspacing="0" cellpadding="0"><tbody><tr><td style="padding: 6px; border-right-color: rgb(229, 229, 229); border-right-width: 2px; border-right-style: solid;"><div style='margin: 0px; padding: 0px; text-align: right; color: rgb(102, 102, 102); line-height: 130%; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important; -ms-word-break: normal;'><div style="line-height: 130%;">1</div><div style="line-height: 130%;">2</div><div style="line-height: 130%;">3</div><div style="line-height: 130%;">4</div><div style="line-height: 130%;">5</div><div style="line-height: 130%;">6</div><div style="line-height: 130%;">7</div><div style="line-height: 130%;">8</div><div style="line-height: 130%;">9</div><div style="line-height: 130%;">10</div><div style="line-height: 130%;">11</div><div style="line-height: 130%;">12</div><div style="line-height: 130%;">13</div></div></td><td style="padding: 6px 0px;"><div style='margin: 0px; padding: 0px; color: rgb(1, 1, 1); line-height: 130%; font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace !important;'><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"><span style="color: rgb(167, 29, 93);">public</span> <span style="color: rgb(167, 29, 93);">void</span> ExportExcel()</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> {</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.Clear();</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.ClearHeaders();</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.Buffer <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">=</span> <span style="color: rgb(167, 29, 93);">true</span>;</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.AddHeader(<span style="color: rgb(99, 163, 92);">"content-disposition"</span>, <span style="color: rgb(99, 163, 92);">"attachment; filename="</span> <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">+</span> <span style="color: rgb(99, 163, 92);">"대리점등록_"</span> <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">+</span> DateTime.Now.ToString(<span style="color: rgb(99, 163, 92);">"yyyy_MM_dd"</span>) <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">+</span> <span style="color: rgb(99, 163, 92);">".xls"</span>);</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.Charset <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">=</span> <span style="color: rgb(99, 163, 92);">"utf-8"</span>;</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.ContentType <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">=</span> <span style="color: rgb(99, 163, 92);">"application/vnd.xls"</span>;</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> </div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> <span style="color: rgb(167, 29, 93);">string</span> table <span style="color: rgb(0, 134, 179);"></span><span style="color: rgb(167, 29, 93);">=</span> @<span style="color: rgb(99, 163, 92);">"<Table style='font-size:16px; font-weight:bold;'><tr style='text-align:center;'><td colspan='9'>대리점등록</td></tr><tr><td colspan='9'></td></tr></Table>"</span>;</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.<span style="color: rgb(6, 109, 226);">Write</span>(table);</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> Response.End();</div><div style="padding: 0px 6px; line-height: 130%; white-space: pre;"> }</div></div><div style="text-align: right; font-size: 9px; font-style: italic; margin-top: -13px; margin-right: 5px;"><a style="color: rgb(229, 229, 229); text-decoration: none;" href="http://colorscripter.com/info#e" target="_blank">Colored by Color Scripter</a></div></td><td style="padding: 0px 2px 4px 0px; vertical-align: bottom;"><a style="color: white; text-decoration: none;" href="http://colorscripter.com/info#e" target="_blank"><span style="padding: 1px; border-radius: 10px; color: white; font-size: 9px; -ms-word-break: normal; background-color: rgb(229, 229, 229);">cs</span></a></td></tr></tbody></table></div><p><br></p><p><br></p>
<!-- -->
]]>
카페 게시글
ASP.NET 질문
excel 파일 추출할 때 한글 깨짐 문제
앵두야
추천 0
조회 2,792
16.04.14 11:15
댓글 5
북마크 번역하기 공유하기 기능 더보기
다음검색
첫댓글 오래되서 기억이 잘안나지만 Server.UrlEncode("대리점등록_" )
System.Web.HttpUtility.UrlEncode(fileName).Replace("+","%20"));
오.. 두 방법 모두 잘 됩니다. 감사합니다..ㅎㅎㅎ header 해결해서 좋아라 하고 있었는데.... 이젠 컨텐츠가 문제네요. 같은 방식으로 table 도 인코딩시켜봤는데 표가 만들어지지 않고 이런식으로 변환이 되어버립니다.
%3cTable+style%3d%27font-size%3a16px%3b+font- .......
컨텐츠 쪽은 인코딩을 다르게 적용시켜야 되는건가요? ㅠ
http://blog.naver.com/PostView.nhn?blogId=ssayagain&logNo=90086935981
도저히 안돼서 틈틈이 찾다기 드디어 해결했습니다... Response.Write(sw.Tostring()); 하기 전에 메타태그 스크립트도 작성해주었습니다.
Response.Write("<!--[안내]태그제한으로등록되지않습니다-<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />-->");
휴우 드디어...