[php] PHPExcel 에서 숫자 출력

[php] PHPExcel 에서 숫자 출력

 

 

PHPExcel 에서 숫자 출력

 

1. 스트링으로 변환하여 number_format 사용하는 방법

 

$PHPExcel->getActiveSheet()->setCellValue('A0', '123456789012');

 

을 다음과 같이 변경

 

$PHPExcel->getActiveSheet()->setCellValueExplicit('A0', '123456789012', PHPExcel_Cell_DataType::TYPE_STRING);

 

 

2. 숫자형으로 변환하고 콤마찍는 방법

 

$PHPExcel->getActiveSheet()->setCellValueExplicit("A0","12345",PHPExcel_Cell_DataType::TYPE_NUMERIC);

$PHPExcel->getActiveSheet()->getStyle("A0")->getNumberFormat()->setFormatCode("#,##0");

 

 

출처 : https://m.blog.naver.com/PostView.nhn?blogId=itws&logNo=220942905322