/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

1 vote354 views1 answer
How delete the table in laravel in the commend
PHP Laravel
3 votes343 views1 answer
Count array laravel
PHP Laravel
0 vote389 views1 answer
Laravel create new file if not exists
PHP Laravel
18 votes388 views1 answer
Laravel migation error
PHP Laravel
0 vote379 views1 answer
Laravel collection reverse
PHP Laravel
2 votes381 views2 answers
Laravel validate form data unique
PHP Laravel
2 votes382 views3 answers
How to share a helper globally laravel
PHP Laravel
0 vote340 views1 answer
Laravel count soft delete data
PHP Laravel
1 vote365 views1 answer
Laravel where column different
PHP Laravel
0 vote411 views2 answers
Convert string to array laravel
PHP Laravel