/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 vote377 views1 answer
Nova laravel image
PHP Laravel
0 vote292 views2 answers
Check empty laravel blade
PHP Laravel
2 votes341 views3 answers
Laravel auth check login
PHP Laravel
1 vote342 views1 answer
Laravel create search
PHP Laravel
0 vote325 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel
1 vote310 views3 answers
Laravel eloquent bulk insert
PHP Laravel
35 votes323 views6 answers
Laravel db query
PHP Laravel
1 vote291 views1 answer
Use username instead of email laravel
PHP Laravel
0 vote330 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
0 vote324 views1 answer
Laravel make migration in subfolder
PHP Laravel