엑셀 다운 확장명오류 채택완료

</p>

<p><?php</p>

<p>  include_once('./_common.php');</p>

<p>  function column_char($i) { return chr( 65 + $i ); }</p>

<p>  include_once(G5_LIB_PATH.'/PHPExcel.php');</p>

<p>  // $bo_table = $_GET["bo_table"];</p>

<p>  $bo_table = "s_shop_item";</p>

<p>  // $wr_id = $_GET["wr_id"];</p>

<p>  $headers = array('');</p>

<p>  $widths  = array(20);</p>

<p>  // $header_bgcolor = 'FFABCDEF';</p>

<p>  $header_bgcolor = 'FFFFFF';</p>

<p>  $last_char = column_char(count($headers) - 1);</p>

<p>  $sql = " select * from $bo_table";</p>

<p>  $result = sql_query($sql);</p>

<p>  for($i=1; $row=sql_fetch_array($result); $i++) {</p>

<p>      $rows[] =</p>

<p>    array($row['it_id'],  </p>

<p>    $row['ca_id'],  </p>

<p>    $row['ca_id2'],  </p>

<p>    $row['ca_id3'],  </p>

<p>    $row['it_skin'],  </p>

<p>    $row['it_mobile_skin'],  </p>

<p>    $row['it_name'],  </p>

<p>    $row['it_maker'],  </p>

<p>    $row['it_origin'],  </p>

<p>    $row['it_brand'],  </p>

<p>    $row['it_model'],  </p>

<p>    $row['it_option_subject'],  </p>

<p>    $row['it_supply_subject'],  </p>

<p>    $row['it_type1'],  </p>

<p>    $row['it_type2'],</p>

<p>    $row['it_type3'],</p>

<p>    $row['it_type4'],</p>

<p>    $row['it_type5'],</p>

<p>    $row['it_basic'],</p>

<p>    $row['it_explan'],</p>

<p>    $row['it_explan2'],</p>

<p>    $row['it_mobile_explan'],</p>

<p>    $row['it_cust_price'],</p>

<p>    $row['it_price'],</p>

<p>    $row['it_point'],</p>

<p>    $row['it_point_type'],</p>

<p>    $row['it_supply_point'],</p>

<p>    $row['it_notax'],</p>

<p>    $row['it_sell_email'],</p>

<p>    $row['it_use'],</p>

<p>    $row['it_nocoupon'],</p>

<p>    $row['it_soldout'],</p>

<p>    $row['it_stock_qty'],</p>

<p>    $row['it_stock_sms'],</p>

<p>    $row['it_noti_qty'],</p>

<p>    $row['it_sc_type'],</p>

<p>    $row['it_sc_method'],</p>

<p>    $row['it_sc_price'],</p>

<p>    $row['it_sc_minimum'],</p>

<p>    $row['it_sc_qty'],</p>

<p>    $row['it_buy_min_qty'],</p>

<p>    $row['it_buy_max_qty'],</p>

<p>    $row['it_head_html'],</p>

<p>    $row['it_tail_tml'],</p>

<p>    $row['it_mobile_head_html'],</p>

<p>    $row['it_mobile_tail_html'],</p>

<p>    $row['it_hit'],</p>

<p>    $row['it_time'],</p>

<p>    $row['it_update_time'],</p>

<p>    $row['it_ip'],</p>

<p>    $row['it_order'],</p>

<p>    $row['it_tel_inq'],</p>

<p>    $row['it_info_gubun'],</p>

<p>    $row['it_info_value'],</p>

<p>    $row['it_sum_qty'],</p>

<p>    $row['it_use_cnt'],</p>

<p>    $row['it_use_avg'],</p>

<p>    $row['it_shop_memo'],</p>

<p>    $row['ec_mall_pid'],</p>

<p>    $row['it_img1'],</p>

<p>    $row['it_img2'],</p>

<p>    $row['it_img3'],</p>

<p>    $row['it_img4'],</p>

<p>    $row['it_img5'],</p>

<p>    $row['it_img6'],</p>

<p>    $row['it_img7'],</p>

<p>    $row['it_img8'],</p>

<p>    $row['it_img9'],</p>

<p>    $row['it_img10'],</p>

<p>    $row['it_1_subj'],</p>

<p>    $row['it_2_subj'],</p>

<p>    $row['it_3_subj'],</p>

<p>    $row['it_4_subj'],</p>

<p>    $row['it_5_subj'],</p>

<p>    $row['it_6_subj'],</p>

<p>    $row['it_7_subj'],</p>

<p>    $row['it_8_subj'],</p>

<p>    $row['it_9_subj'],</p>

<p>    $row['it_10_subj'],</p>

<p>    $row['it_1'],</p>

<p>    $row['it_2'],</p>

<p>    $row['it_3'],</p>

<p>    $row['it_4'],</p>

<p>    $row['it_5'],</p>

<p>    $row['it_6'],</p>

<p>    $row['it_7'],</p>

<p>    $row['it_8'],</p>

<p>    $row['it_9'],</p>

<p>    $row['it_10'],</p>

<p>    $row['pt_tag'],</p>

<p>    $row['pt_thumb'],</p>

<p>    $row['pt_link1'],</p>

<p>    $row['pt_link2'],</p>

<p>    $row['pt_map'],</p>

<p>    $row['pt_id'],</p>

<p>    $row['pt_it'],</p>

<p>    $row['pt_ccl'],</p>

<p>    $row['pt_img'],</p>

<p>    $row['pt_file'],</p>

<p>    $row['pt_main'],</p>

<p>    $row['pt_point'],</p>

<p>    $row['pt_order'],</p>

<p>    $row['pt_commission'],</p>

<p>    $row['pt_incentive'],</p>

<p>    $row['pt_marketer'],</p>

<p>    $row['pt_review_use'],</p>

<p>    $row['pt_comment_use'],</p>

<p>    $row['pt_comment'],</p>

<p>    $row['pt_qa'],</p>

<p>    $row['pt_good'],</p>

<p>    $row['pt_nogood'],</p>

<p>    $row['pt_show'],</p>

<p>    $row['pt_num'],</p>

<p>    $row['pt_day'],</p>

<p>    $row['pt_end'],</p>

<p>    $row['pt_reserve'],</p>

<p>    $row['pt_reserve_use'],</p>

<p>    $row['pt_syndi'],</p>

<p>    $row['pt_explan'],</p>

<p>    $row['pt_mobile_explan'],</p>

<p>    $row['pt_msg1'],</p>

<p>    $row['pt_msg2'],</p>

<p>    $row['pt_msg3']);</p>

<p>}</p>

<p>$data = array_merge(array($headers), $rows);</p>

<p>$excel = new PHPExcel();</p>

<p>$excel->setActiveSheetIndex(0)->getStyle( "A1:${last_char}1" )->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($header_bgcolor);</p>

<p>$excel->setActiveSheetIndex(0)->getStyle( "A:$last_char" )->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setWrapText(true);</p>

<p>foreach($widths as $i => $w) $excel->setActiveSheetIndex(0)->getColumnDimension( column_char($i) )->setWidth($w);</p>

<p>$excel->getActiveSheet()->fromArray($data,NULL,'A1');</p>

<p>header("Content-Type: application/octet-stream");</p>

<p>header("Content-Disposition: attachment; filename=\"shop_item-".date("ymd", time()).".xls\"");</p>

<p>header("Cache-Control: max-age=0");</p>

<p>$writer = PHPExcel_IOFactory::createWriter($excel, 'Excel5');</p>

<p>$writer->save('php://output');</p>

<p>?></p>

<p>