웹페이지를 엑셀로 다운할때 틀고정 freezepan
더시민
3
2213
0
2021.09.10 17:41
퍼옴
아래와 같이 코드를 구성하시면
위에 세로 한줄과 가로첫컬럼이 틀고정됩니다.
틀 고정을 위한 소스는 밑에 굵고 진하게 표시하겠습니다.
<%
response.buffer=true
Response.ContentType = "application/vnd.ms-excel; name='My_Excel'"
Response.AddHeader "Content-Disposition","attachment;filename=선번장.xls"
%>
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>나의 엑셀</x:Name>
<x:WorksheetOptions>
<x:DoNotDisplayGridlines/>
<x:FreezePanes/>
<x:FrozenNoSplit/>
<x:SplitHorizontal>1</x:SplitHorizontal>
<x:TopRowBottomPane>1</x:TopRowBottomPane>
<x:SplitVertical>1</x:SplitVertical>
<x:LeftColumnRightPane>1</x:LeftColumnRightPane>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>나의 엑셀</x:Name>
<x:WorksheetOptions>
<x:DoNotDisplayGridlines/>
<x:FreezePanes/>
<x:FrozenNoSplit/>
<x:SplitHorizontal>1</x:SplitHorizontal>
<x:TopRowBottomPane>1</x:TopRowBottomPane>
<x:SplitVertical>1</x:SplitVertical>
<x:LeftColumnRightPane>1</x:LeftColumnRightPane>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body>
<table>
<tr>
<td>이름</td><td>성별</td><td>비고</td>
</tr>
<tr>
<td>천상태자</td><td>남자</td><td>난 나야</td>
</tr>
<tr>
<td>행복나무</td><td>여자</td><td>태자 마누라</td>
</tr>
이후 데이터는 주루룩~ 넣어보시구염.
</body>
</html>
</body>
</html>