CODEWITHSUNDEEP
phpphpexcelnumber-formatting
Phill Pafford
Phill Pafford

Reputation: 85308

phpExcel write long number in cell

While writing the excel file is fine I see that really long numbers are formulas in excel

Example: 8.71129E+12

instead of: 1234567890

How can I change the format during the PHP Excel Creation?

I'm following the simple example here

Upvotes: 10

Views: 18504

Answers (3)

MISSIRIA
MISSIRIA

Reputation: 456

Try this code it's works for me :

$objPHPExcel
   ->getActiveSheet()
   ->getCellByColumnAndRow($col, $row)
   ->setValueExplicit($value, PHPExcel_Cell_DataType::TYPE_STRING);

And Good luck !

Upvotes: 1

Mark Baker
Mark Baker

Reputation: 212412

Either set the value explicitly as a string, or set a number format mask for the cell that forces display of all digits (e.g. '#,##0' 0r '0') rather than default format.

Upvotes: 4

Sarwar Erfan
Sarwar Erfan

Reputation: 18068

$objPHPExcel->getActiveSheet()->setCellValueExplicit('A1', '1234567890', PHPExcel_Cell_DataType::TYPE_STRING);

Upvotes: 28

Related Questions