How to beat "number saved as text" error in PHPExcel?

Question

PHP

Hello everyone, when driving in a cell, msExcel swears at numbers, saying that the number is stored as text

Tried through the setValueExplicit method indicating the type. Did not help

$worksheet->getCell('L'.$row)->setValueExplicit($p->getQuantity(), \PHPExcel_Cell_DataType::TYPE_STRING);

Answer 1

Have you tried it like this? should help)

$worksheet->getCell('L'.$row)->setValueExplicit($p->getQuantity(), \PHPExcel_Cell_DataType::TYPE_NUMERIC);