How to make PHPExcell return the correct field?

Question

PHP

Good morning, I guess.
After reading the file using PHPExcel, I ran into a problem that it converts a bank account (20 digits) into an exponent (since Excel only likes 15 digit lines)
I tried to getFormattedValue, but somehow everything was unsuccessful.
Can you tell me in which direction to pick?

Answer 1

After breaking my head, looking at what var_dump produces with different configurations.
I did not find anything better than to change a little code in the PHPExcel/Cell.php file: We are
looking for public function setValueExplicit, in it we change
case PHPExcel_Cell_DataType::TYPE_NUMERIC:
$this->_value = (float)$pValue;
on
case PHPExcel_Cell_DataType::TYPE_NUMERIC:
$this->_value = (string)$pValue;
But this is only for my case and is not a panacea.

Answer 2

have you tried getCalculatedValue?

Answer 3

you can do this:
$number = 0012;
$sheet->setCellValue("B1", $number);
$sheet->getStyle("B1")->getNumberFormat()->setFormatCode('0000');