Long numbers exported by PHPExcel are solved by scientific notation conversion and missing data-PHP Tutorial-php.cn

Long numbers exported by PHPExcel are solved by scientific notation conversion and missing data

WBOY

Release： 2016-08-08 09:19:16

Original

2367 people have browsed it

The F column of the EXCEL table is a long number, such as 2015072708542427700014133717. After exporting, it will become 201507270854242770001410000. Search the Internet for solutions. The first solution is to set the F column in string form, as follows

$objPHPExcel = new PHPExcel() ;

//Set column F (order number) to text format
$objPHPExcel->getActiveSheet()->getStyle('F')->getNumberFormat()
->setFormatCode( PHPExcel_Style_NumberFormat::FORMAT_TEXT);
$i=1;
foreach($info as $row){
$asc2 = 65;
foreach($row as $field){
$ objPHPExcel->setActiveSheetIndex(0)->setCellValue(chr($asc2++).$i, $field);
}
$i++;

}The result failed, maybe setting the format something went wrong.

Then continue searching and find the second way

// operate the first worksheet
$objPHPExcel->setActiveSheetIndex(0);
$i=1;
foreach($ info as $row){
$asc2 = 65;
foreach($row as $field){
$objPHPExcel->getActiveSheet()->setCellValueExplicit(chr($asc2++).$ i, $field, PHPExcel_Cell_DataType::TYPE_STRING);
}
$i++;
}Specify the type of this data when setting the cell, and it will be successful.

Copyright Statement: This article is an original article by the blogger and may not be reproduced without the blogger's permission.

The above introduces the solution to the problem of missing data when long numbers exported by PHPExcel are converted into scientific notation, including aspects of the problem. I hope it will be helpful to friends who are interested in PHP tutorials.