엑셀 셀 늘리기 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

엑셀 셀 늘리기 정보

엑셀 셀 늘리기

본문

<?
    header('Content-Type: application/vnd.ms-excel');
    header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    header('Content-Disposition: attachment; filename="account_' . date("ymd", time()) . '.xls"');
 header("Cache-control: private"); 
    header('Pragma: public');
    header('content-transfer-encoding: binary');


$list = unserialize(urldecode($_REQUEST["tmp0"]));
$all_add = unserialize(urldecode($_REQUEST["tmp1"]));
echo '<?xml version="1.0"?>'."\n";
echo '<?mso-application progid="Excel.Sheet"?>'."\n";
?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Version>11.5606</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowTopX>360</WindowTopX>
  <WindowTopY>120</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="m19728836">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19728846">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19728856">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19728866">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743460">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743470">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743480">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743490">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729408">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729418">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729428">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729438">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729296">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729306">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729316">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729326">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s21">
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s22">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s35">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s36">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
   <NumberFormat ss:Format="Short Date"/>
  </Style>
  <Style ss:ID="s37">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
   <NumberFormat ss:Format=""\"#,##0"/>
  </Style>
  <Style ss:ID="s38">
   <Alignment ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s43">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="<?=date("y", time())?>년_간편장부">
  <Table ss:ExpandedColumnCount="12" ss:ExpandedRowCount="<?=count($list)+5 ?>" x:FullColumns="1"
   x:FullRows="1" ss:StyleID="s21" ss:DefaultColumnWidth="60"
   ss:DefaultRowHeight="12">
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="33.75"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="55.5"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="103.5"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="43.5"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="90"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="61.5"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="61.5"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="61.5"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/>
   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="67.5"/>
   <Row ss:AutoFitHeight="0">
    <Cell ss:MergeDown="1" ss:StyleID="m19743460"><Data ss:Type="String">번호</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m19743470"><Data ss:Type="String">날짜</Data></Cell>
    <Cell ss:MergeAcross="1" ss:MergeDown="1" ss:StyleID="m19743480"><Data
      ss:Type="String">거래내역</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m19743490"><Data ss:Type="String">거래처</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m19728836"><Data ss:Type="String">수입</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m19728846"><Data ss:Type="String">비용</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m19728856"><Data ss:Type="String">고정자산증감</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m19728866"><Data ss:Type="String">비고</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:Index="6" ss:StyleID="s22"><Data ss:Type="String">금액</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">부가세</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">금액</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">부가세</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">금액</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">부가세</Data></Cell>
   </Row>
<?
for ($i=0; $i<count($list); $i++) :
 // 돈놀이
 for ($j=3; $j<=10; $j++) :
  if($j != 9) {
  $y = "wr_$j";
  $page_add[$y] = $list[$i][$y] + $page_add[$y];
  }
 endfor;
$list[$i][wr_1] = substr($list[$i][wr_1],0,4)."-".substr($list[$i][wr_1],4,2)."-".substr($list[$i][wr_1],6,2);
if($list[$i][wr_10]) $list[$i][wr_10] = number_format($list[$i][wr_10]);
?>
   <Row ss:AutoFitHeight="0" ss:Height="25">
    <Cell ss:StyleID="s35"><Data ss:Type="Number"><?=$list[$i][num]?></Data></Cell>
    <Cell ss:StyleID="s36"><Data ss:Type="DateTime"><?=$list[$i][wr_1]?></Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][subject]?></Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][ca_name]?></Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][wr_2]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$list[$i][wr_3]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$list[$i][wr_4]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$list[$i][wr_5]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$list[$i][wr_6]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$list[$i][wr_7]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$list[$i][wr_8]?></Data></Cell>
    <Cell ss:StyleID="s38"><Data ss:Type="String"><?=$list[$i][wr_9]?><? if($list[$i][wr_9]) echo ' '.$list[$i][wr_10]; ?></Data></Cell>
   </Row>
<?
endfor;
?>
  <Row ss:AutoFitHeight="0" ss:Height="24.9375">
    <Cell ss:MergeAcross="4" ss:StyleID="s43"><Data ss:Type="String">누계</Data></Cell>
<? foreach($page_add as $value) : ?>
 <Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$value?></Data></Cell>
<? endforeach; ?>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Unsynced/>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <Scale>52</Scale>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>600</VerticalResolution>
   </Print>
   <PageBreakZoom>60</PageBreakZoom>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <RangeSelection>R1C1:R2C1</RangeSelection>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
<?
    exit;
?>

위와 같은 엑셀출력파일을 사용중입니다.
리스트에 글목록수를 200개 정도로 늘리고 엑셀로 저장해서 열어보면 테이블에러 라고 하면서 안열립니다.
게시물이 많아져서 페이지가 넘어가는데 엑셀로 저장하면 그 페이지 내용만 저장되어서 보여지네요.
한꺼번에 전체 내용을 다 엑셀로 저장하고 싶은데 방법이 없을까요?
도움을 부탁드립니다.
꾸벅

  • 복사

댓글 전체

서누니 홈페이지 자기소개 아이디로 검색 회원게시물 09.11.15 17:21:44
아 제가 깨작거렸던거네요. 저도 동일한 문제가 있어서 수정은 했으나 좀 많이 뜯어고친거라.

저거는 아직..

음...............저 스킨작업할때 해당 페이지만 엑셀로 그려서요.

그렇게 바쁘시지 않으면 좀 기다려 주심이

안그래도 요즘 기존 스킨들 다시 손볼려고 워밍업중인데... 일감이 쌓여서 손을 아직 못 되었네요.
서누니 홈페이지 자기소개 아이디로 검색 회원게시물 09.11.16 05:43:02
<?
    header('Content-Type: application/vnd.ms-excel');
    header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    header('Content-Disposition: attachment; filename="list_' . date("ymd", time()) . '.xls"');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    header('content-transfer-encoding: binary');

$list = unserialize(urldecode($_REQUEST["tmp0"]));
$all_add = unserialize(urldecode($_REQUEST["tmp1"]));
echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Version>11.5606</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowTopX>360</WindowTopX>
  <WindowTopY>120</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
  <Alignment ss:Vertical="Center"/>
  <Borders/>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  <Interior/>
  <NumberFormat/>
  <Protection/>
  </Style>
  <Style ss:ID="m19728836">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19728846">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19728856">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19728866">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743460">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743470">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743480">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19743490">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729408">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729418">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729428">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729438">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729296">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729306">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729316">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="m19729326">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s21">
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s22">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern" ss:Bold="1"/>
  <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s35">
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s36">
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  <NumberFormat ss:Format="Short Date"/>
  </Style>
  <Style ss:ID="s37">
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  <NumberFormat ss:Format="&quot;\&quot;#,##0"/>
  </Style>
  <Style ss:ID="s38">
  <Alignment ss:Vertical="Center" ss:WrapText="1"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s43">
  <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
  </Borders>
  <Font ss:FontName="돋움" x:CharSet="129" x:Family="Modern"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="<?=date("y", time())?>년_간편장부">
  <Table ss:ExpandedColumnCount="12" ss:ExpandedRowCount="<?=count($list)+5?>" x:FullColumns="1"
  x:FullRows="1" ss:StyleID="s21" ss:DefaultColumnWidth="60"
  ss:DefaultRowHeight="12">
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="33.75"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="55.5"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="103.5"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="43.5"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="90"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="61.5"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="61.5"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="61.5"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/>
  <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="67.5"/>
  <Row ss:AutoFitHeight="0">
    <Cell ss:MergeDown="1" ss:StyleID="m19743460"><Data ss:Type="String">번호</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m19743470"><Data ss:Type="String">날짜</Data></Cell>
    <Cell ss:MergeAcross="1" ss:MergeDown="1" ss:StyleID="m19743480"><Data
      ss:Type="String">거래내역</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m19743490"><Data ss:Type="String">거래처</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m19728836"><Data ss:Type="String">수입</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m19728846"><Data ss:Type="String">비용</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m19728856"><Data ss:Type="String">고정자산증감</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m19728866"><Data ss:Type="String">비고</Data></Cell>
  </Row>
  <Row ss:AutoFitHeight="0">
    <Cell ss:Index="6" ss:StyleID="s22"><Data ss:Type="String">금액</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">부가세</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">금액</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">부가세</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">금액</Data></Cell>
    <Cell ss:StyleID="s22"><Data ss:Type="String">부가세</Data></Cell>
  </Row>
<?
for ($i=0; $i<count($list); $i++) :
// 돈놀이
for ($j=3; $j<=10; $j++) :
if($j != 9) {
$y = "wr_$j";
$page_add[$y] = $list[$i][$y] + $page_add[$y];
}
endfor;
$list[$i][wr_1] = substr($list[$i][wr_1],0,4)."-".substr($list[$i][wr_1],4,2)."-".substr($list[$i][wr_1],6,2);
if($list[$i][wr_10]) $list[$i][wr_10] = number_format($list[$i][wr_10]);
?>
  <Row ss:AutoFitHeight="0" ss:Height="25">
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][num]?></Data></Cell>
    <Cell ss:StyleID="s36"><Data ss:Type="String"><?=$list[$i][wr_1]?></Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][subject]?></Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][ca_name]?></Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String"><?=$list[$i][wr_2]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="String"><?=$list[$i][wr_3]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="String"><?=$list[$i][wr_4]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="String"><?=$list[$i][wr_5]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="String"><?=$list[$i][wr_6]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="String"><?=$list[$i][wr_7]?></Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="String"><?=$list[$i][wr_8]?></Data></Cell>
    <Cell ss:StyleID="s38"><Data ss:Type="String"><?=$list[$i][wr_9]?><? if($list[$i][wr_9]) echo '&#10;'.$list[$i][wr_10]; ?></Data></Cell>
  </Row>
<?
endfor;
?>
  <Row ss:AutoFitHeight="0" ss:Height="24.9375">
    <Cell ss:MergeAcross="4" ss:StyleID="s43"><Data ss:Type="String">누계</Data></Cell>
<? foreach($page_add as $value) : ?>
<Cell ss:StyleID="s37"><Data ss:Type="Number"><?=$value?></Data></Cell>
<? endforeach; ?>
  </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
  <Unsynced/>
  <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <Scale>52</Scale>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>600</VerticalResolution>
  </Print>
  <PageBreakZoom>60</PageBreakZoom>
  <Selected/>
  <Panes>
    <Pane>
    <Number>3</Number>
    <RangeSelection>R1C1:R2C1</RangeSelection>
    </Pane>
  </Panes>
  <ProtectObjects>False</ProtectObjects>
  <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
<?
    exit;
?>
현재 그대로
일단 출력만 되게 수정했습니다.
Number 타입을 모두 스트링 타입으로 하면 문제없습니다.
입력할때 문제인데. 음.
목록
문의 PC 버전
© SIRSOFT
현재 페이지 제일 처음으로