Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > How to solve the problem of converting numbers into scientific notation when exporting data to excel

How to solve the problem of converting numbers into scientific notation when exporting data to excel

WBOY

Release： 2016-07-25 09:05:44

Original

1677 people have browsed it

//In the excel.php file
$objActSheet = $objPHPExcel->getActiveSheet();
//Set the column name
$objActSheet->setCellValue("b1", "Card Number");
//Set the width of the column
$objActSheet->getColumnDimension('b')->setWidth(20);//Change the length value set here

Copy code

2. The characters are excel If you understand it as a number, you usually set the field to text or find a way to add some spaces. Solution:

//Add data, mainly process the data to be displayed with the chunk_split() function. You can check the specific usage of this function by yourself
$objActSheet->setCellValue ( "b$i", chunk_split( "123456789 ",4," ") );//Of course, if you don't want users to see spaces between numbers, then set the field value to be divided larger. For example, set 4 in the example to greater than or equal to 9. Can.

Copy code

Related labels：

导出数据到excel时数字变为科学计数的解决方法

source：php.cn

Previous article：php-redis Chinese Document 2 Next article：How to add ftp extension without recompiling php

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