웹페이지를 엑셀로 다운할때 틀고정 freezepan

웹페이지를 엑셀로 다운할때 틀고정 freezepan

더시민 3 941 0
퍼옴
아래와 같이 코드를 구성하시면
위에 세로 한줄과 가로첫컬럼이 틀고정됩니다.
틀 고정을 위한 소스는 밑에 굵고 진하게 표시하겠습니다.
 
<%

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>
<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>

3 Comments
더시민 2021.09.10 18:51  
선택제한박스
선택
select option 형태

<xsd:element name="EnableSelection" minOccurs="0" >
  <xsd:simpleType>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="UnlockedCells" />
      <xsd:enumeration value="NoSelection" />
    </xsd:restriction>
  </xsd:simpleType>
</xsd:element>
더시민 2021.09.10 18:51  
선택제한박스
선택
select option 형태

<xsd:element name="EnableSelection" minOccurs="0" >
  <xsd:simpleType>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="UnlockedCells" />
      <xsd:enumeration value="NoSelection" />
    </xsd:restriction>
  </xsd:simpleType>
</xsd:element>
더시민 2021.09.10 18:21  
그냥 위에 2줄 고정이면
<x:SplitHorizontal>2</x:SplitHorizontal>
    <x:TopRowBottomPane>2</x:TopRowBottomPane>
제목
Category
Facebook Twitter GooglePlus KakaoStory KakaoTalk NaverBand