/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 vote152 views1 answer
Laravel array cast
PHP Laravel
1 vote118 views1 answer
Laravel add auto increment
PHP Laravel
1 vote112 views2 answers
How to delete a file in laravel
PHP Laravel
0 vote115 views1 answer
Laravel collection pop
PHP Laravel
5 votes117 views2 answers
Laravel 5 use env variable in blade
PHP Laravel
0 vote119 views1 answer
Laravel cron job on shared hosting
PHP Laravel
20 votes121 views2 answers
Schema error laravel
PHP Laravel
0 vote112 views1 answer
How use same method in another class in laravel
PHP Laravel
3 votes154 views2 answers
Laravel model exists id
PHP Laravel
1 vote114 views1 answer
Messed up pagination laravel
PHP Laravel