/PHP/Laravel/Laravel Excel numbers formatted as text still appearing as number

Laravel Excel numbers formatted as text still appearing as number

I found a workaround by using setCellValueExplicit()
eg:

$sheet->setColumnFormat(array( //se formatea la columna a texto
    'C' => \PHPExcel_Style_NumberFormat::FORMAT_TEXT,
    'I' => 'dd-mm-yyyy hh:mm'
));

$sheet->setCellValueExplicit('C10', $object->card_number, \PHPExcel_Cell_DataType::TYPE_STRING);

Hope this helps ;)

Similar codes

0 vote243 views1 answer
Export laravel path fedora
PHP Laravel
0 vote246 views1 answer
Laravel collection has
PHP Laravel
0 vote252 views1 answer
Laravel app running in console
PHP Laravel
3 votes255 views2 answers
How to add values to an array in laravel
PHP Laravel
6 votes314 views2 answers
Laravel migration integer
PHP Laravel
31 votes250 views6 answers
Make model with migration laravel
PHP Laravel
0 vote228 views2 answers
Laravel pdf export
PHP Laravel
14 votes261 views6 answers
How to install laravel
PHP Laravel
1 vote239 views1 answer
Increment single column laravel
PHP Laravel
1 vote228 views2 answers
Laravel query relationship nested
PHP Laravel