Call to undefined method PHPExcel_Cell::setCellValue()
본문
$objPHPExcel = new PHPExcel();
//$xls_5 = date("mdhis");
$xls_date = date('Ymd'); //배송일
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', '배송번호')
->setCellValue('B1', '주문번호')
->setCellValue('C1', '주문일')
->setCellValue('D1', '주문상태')
->setCellValue('E1', '발송기한')
->setCellValue('F1', '구매번호')
->setCellValue('G1', '상품번호')
->setCellValue('H1', '상품명')
->setCellValue('I1', '옵션')
->setCellValue('J1', '수량')
->setCellValue('K1', '상품금액')
->setCellValue('L1', '총상품금액')
->setCellValue('M1', '구매자')
->setCellValue('N1', '구매자 휴대폰')
->setCellValue('O1', '받는사람')
->setCellValue('P1', '받는사람 연락처')
->setCellValue('Q1', '배송방법')
->setCellValue('R1', '택배사')
->setCellValue('S1', '송장번호')
->setCellValue('T1', '배송예정일')
->setCellValue('U1', '우편번호')
->setCellValue('V1', '주소')
->setCellValue('W1', '배송메세지')
->setCellValue('X1', '배송비지급')
->setCellValue('Y1', '결제일')
->setCellValue('Z1', '주문확인일')
->setCellValue('AA1', '2차발송기한')
->setCellValue('AB1', '업체상품코드')
->setCellValue('AC1', '업체옵션코드')
->setCellValue('AD1', '개인통관고유번호');
for($i=2;$row = sql_fetch_array($result);$i++) {
// Add some data
$wm_jumun = $row['xls_jumun'];
$wm_jumun2 = $row['xls_jumun2'];
$wm_result = "";
$wm_row = "";
$wm_result = " select * from wm where b = '$wm_jumun' and f = '$wm_jumun2' ";
$wm_row = sql_fetch($wm_result);
//$cp_row['a'] = (string)$cp_row['a'];
//$cp_row['b'] = (string)$cp_row['b'];
//$cp_row['c'] = (string)$cp_row['c'];
//$cp_row['d'] = (string)$cp_row['d'];
//$row['xls_4'] = (string)$row['xls_4'];
$objPHPExcel->getActiveSheet()->getStyle(bla,bla)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValueExplicit('A'.$i, $wm_row['a'],PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('B'.$i, $wm_row['b'],PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('C'.$i, $wm_row['c'],PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('D'.$i, $wm_row['d'],PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('E'.$i, $wm_row['e'],PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('F'.$i, $wm_row['f'])
->setCellValue('G'.$i, $wm_row['g'])
->setCellValue('H'.$i, $wm_row['h'])
->setCellValue('I'.$i, $wm_row['i'])
->setCellValue('J'.$i, $wm_row['j'])
->setCellValue('K'.$i, $wm_row['k'])
->setCellValue('L'.$i, $wm_row['l'])
->setCellValue('M'.$i, $wm_row['m'])
->setCellValue('N'.$i, $wm_row['n'])
->setCellValueExplicit('O'.$i, $wm_row['o'],PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValue('P'.$i, $wm_row['p'])
->setCellValue('Q'.$i, $wm_row['q'])
->setCellValue('R'.$i, "CJ대한통운")
->setCellValue('S'.$i, $row['xls_4'],PHPExcel_Cell_DataType::TYPE_STRING)
341번줄 ->setCellValue('T'.$i, $xls_date)
->setCellValue('U'.$i, $wm_row['u'])
->setCellValue('V'.$i, $wm_row['v'])
->setCellValue('W'.$i, $wm_row['w'])
->setCellValue('X'.$i, $wm_row['x'])
->setCellValue('Y'.$i, $wm_row['y'])
->setCellValue('Z'.$i, $wm_row['z'])
->setCellValue('AA'.$i, $wm_row['aa'])
->setCellValue('AB'.$i, $wm_row['ab'])
->setCellValue('AC'.$i, $wm_row['ac'])
->setCellValue('AD'.$i, $wm_row['ad']);
} // end for
색상친부분에서 에러가 납니다..;;;
에러는Fatal error: Call to undefined method PHPExcel_Cell::setCellValue() in update4.php on line 341
입니다.