/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 vote350 views1 answer
Italic text in laravel notification
PHP Laravel
0 vote324 views1 answer
Check null if string laravel
PHP Laravel
1 vote334 views1 answer
Laravel $loop interation
PHP Laravel
2 votes345 views1 answer
Get user ip laravel
PHP Laravel
21 votes320 views4 answers
Laravel where not
PHP Laravel
0 vote329 views1 answer
Array of dates laravel
PHP Laravel
0 vote359 views2 answers
How to implement maatwebsite excel in my laravel project
PHP Laravel
4 votes355 views1 answer
Refresh a specific migration in laravel
PHP Laravel
1 vote336 views1 answer
Php laravel string substring
PHP Laravel
16 votes320 views6 answers
Laravel model events
PHP Laravel