엑셀 다운시 스타일,함수 적용하는 방법

프로그래밍/프로그램 팁 관련 |  2011/10/31 18:29
틀고정 및 숫자 콤마적용,합계처리를 하는 방법입니다.
--------------------------------------------------------------------------------------------

<html xmlns:x='urn:schemas-microsoft-com:office:excel'>
<meta http-equiv="Content-Type" content="application/vnd.ms-excel;charset=euc-kr">
<meta http-equiv='cache-control' content='no-cache'>
<meta http-equiv='pragma' content='no-cache'>
<meta name=Generator content="Microsoft Excel 9">


<style>
td{font-size:9pt; font-family:굴림}
br{mso-data-placement:same-cell;}
BR{mso-data-placement:same-cell;}
.title{font-size:12pt;font-weight: bold}
.title2{font-size:8pt;font-weight: normal}
.title3{font-weight: normal;mso-text-control:shrinktofit;white-space:nowrap;}
.font{font-size:9pt}
.int{mso-number-format:"0_ ";mso-text-control:shrinktofit;white-space:nowrap;}/*숫자타입*/
.decimal2{mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\\-\#\,\#\#0\.00\\ ";mso-text-control:shrinktofit;white-space:nowrap;}/*숫자타입(콤마표시,소수점2자리)*/
.percent{mso-style-parent:style0;mso-number-format:Percent;} /*백분율(소수2자리)*/
.other{mso-number-format:"\@";mso-text-control:shrinktofit;white-space:nowrap;}/*문자타입*/
.text{mso-number-format:"\@";mso-text-control:shrinktofit;white-space:nowrap;}/*문자타입*/
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>

<x:ExcelWorksheet>
<x:Name><?=$Excel_Title?></x:Name>
<x:WorksheetOptions>
<x:DefaultRowHeight>270</x:DefaultRowHeight>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>600</x:HorizontalResolution>
<x:VerticalResolution>600</x:VerticalResolution>
</x:Print>
<x:Selected/>

<?if($_POST[Excel_SplitHorizontal] || $_POST[Excel_SplitVertical]){//틀고정시 적용?>
<x:FreezePanes/>
<x:FrozenNoSplit/>
<x:SplitHorizontal><?=$_POST[Excel_SplitHorizontal]?></x:SplitHorizontal>
<x:TopRowBottomPane><?=$_POST[Excel_SplitHorizontal]?></x:TopRowBottomPane>
<x:SplitVertical><?=$_POST[Excel_SplitVertical]?></x:SplitVertical>
<x:LeftColumnRightPane><?=$_POST[Excel_SplitVertical]?></x:LeftColumnRightPane>
<x:ActivePane>0</x:ActivePane>
<?}?>

<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>0</x:ActiveRow>
<x:ActiveCol>0</x:ActiveCol>
<x:RangeSelection>$G$19:$G$20</x:RangeSelection>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>11475</x:WindowHeight>
<x:WindowWidth>17745</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>90</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->

<table border=1>
<tr><td class=int x:num=1000>1000</td></tr>
<tr><td class=int x:num=1000>1000</td></tr>
<tr><td class=int x:num=1000>1000</td></tr>
<tr><td class=int x:fmla='=sum(A1:A3)'></td></tr>
</table>                                       
2011/10/31 18:29 2011/10/31 18:29
No trackbacks, No comments.

Trackback Address :: 이 글에는 트랙백을 보낼 수 없습니다

1 ... 526 527 528 529 530 531 532 533 534 ... 2063