简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

How to handle scientific notation when php exports to excel

PHP中文网
Release： 2023-02-28 20:26:01
Original
4969 people have browsed it

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); 
?>
Copy after login

The above is the content of scientific notation when php exports excel. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com )!

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

Related labels：
php，excel，科学计数法
source：php.cn
Previous article：PHP class to verify email address (classic) Next article：PHP class to connect to mysql database (interface implementation)
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to copy Excel FV function in PHP? I'm converting some fairly complex calculations from an Excel spreadsheet to PHP. I'm stuc...
From 2023-11-04 15:54:09
0
1
254
The rewritten title is: Translate "Php merges two codes (random + length)" into Chinese I need your help to make this work. I need to combine two php codes to work. I am a beginn...
From 2023-09-15 18:14:39
0
1
328
Calculate the number of days in overlapping or non-overlapping date ranges: PHP and Carbon implementation method How to get the number of days for 2 or more potentially overlapping date ranges (CarbonPer...
From 2023-09-09 14:50:29
0
1
245
Is it possible to read and display the contents of a txt file every few seconds using HTML? I have a txt file that is updated with new data every few seconds. It is stored and genera...
From 2023-09-07 08:46:12
0
2
282
Shortest way to convert all PHP types to string I'm writing a general system that I hope can one day be applied to fields like medicine (i...
From 2023-09-05 15:34:44
0
1
359
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！