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

매뉴얼 FAQ
그누보드5
데모
자료실
  • 다운로드
  • 매뉴얼
  • Q&A
    • 창작마당
  • 팁자료실
  • 스킨
  • 빌더
  • 테마
  • 플러그인
  • 사용후기
    • 영카트5
    데모
    자료실
    창작마당
    정기결제
    데모
    자료실
    Q & A
    궁금한 게 있으신가요? 지금 질문해보세요!
    솔루션
    프로그래밍
    서버
    사이트운영
    컨텐츠몰
    나의 재능을 팔아보세요!
    부가서비스
    국내최저! 신용카드 결제수수료 2.85%
    제작의뢰
    커뮤니티
    커뮤니티
    소모임
    스터디
    AI 🌟
    강좌
    기타

    그누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 타입을 모두 스트링 타입으로 하면 문제없습니다.
    입력할때 문제인데. 음.
    전체 66,554 |RSS
    그누4 질문답변 내용 검색

    회원로그인

    (주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
    사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
    © SIRSOFT