/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 vote234 views1 answer
Exists:categories,id except a value laravel
PHP Laravel
2 votes245 views1 answer
Laravel delete relationship data
PHP Laravel
2 votes242 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
0 vote255 views2 answers
Upload video in laravel
PHP Laravel
1 vote253 views1 answer
How validate the value of object in arraye in laravel
PHP Laravel
0 vote251 views1 answer
How to share count of things to sidebar in laravel
PHP Laravel
0 vote237 views1 answer
Import local js file laravel
PHP Laravel
13 votes228 views6 answers
Laravel migration change column type
PHP Laravel
1 vote250 views2 answers
Laravel request all except
PHP Laravel
0 vote266 views2 answers
Laravel get url without domain in blade
PHP Laravel