/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 vote219 views3 answers
Queue jobs in laravel
PHP Laravel
30 votes179 views6 answers
Laravel auth
PHP Laravel
0 vote170 views1 answer
How to collapse array in laravel
PHP Laravel
0 vote165 views1 answer
Laravel display multiple selected values
PHP Laravel
1 vote185 views2 answers
How to get data from a table in laravel
PHP Laravel
3 votes174 views1 answer
Check file size validation laravel
PHP Laravel
15 votes174 views3 answers
Laravel date set timezone
PHP Laravel
7 votes184 views4 answers
Laravel error messages
PHP Laravel
5 votes184 views2 answers
Refresh a specific migration laravel
PHP Laravel
0 vote172 views1 answer
Explode in laravel blade
PHP Laravel