This article introduces a method of scientific notation when exporting excel data using PHP for your reference.
How to implement scientific notation when php exports excel, the code is as follows:
getStyle($this->numToEn($col).($row+2))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $activeSheet->setCellValue($this->numToEn($col).($row+2)," ".$elements[$row][$col]); //写入Excels单元格的内容之前加一个空格，防止长数字被转化成科学计数法 $activeSheet->getStyle($this->numToEn($col).($row+2))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); ?>
The above is the content of scientific notation when php exports excel. For more related content, please pay attention to the PHP Chinese website (www.php.cn )!
Related articles:
Two ways to export excel files natively with php
Details of the sample code for reading Excel time in PHPExcel
A code example for obtaining the content of an excel document through php
Compare the similarities and differences between two columns of data in excel
excel duplicate item filter color
How to copy an Excel table to make it the same size as the original
Excel table slash divided into two
Excel diagonal header is divided into two
Absolute reference input method
java export excel
Excel input value is illegal
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
