/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 vote214 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel
0 vote208 views1 answer
Laravel reset autoload
PHP Laravel
0 vote246 views4 answers
Installing bootstrap on laravel8
PHP Laravel
9 votes214 views4 answers
Laravel merge collections
PHP Laravel
1 vote220 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote211 views2 answers
Where () laravel Eloquent
PHP Laravel
0 vote201 views1 answer
Migration not found laravel
PHP Laravel
6 votes224 views3 answers
Laravel ecommerce
PHP Laravel
0 vote254 views1 answer
Laravel log permission denied mac
PHP Laravel
0 vote223 views1 answer
Logout from all the devices in the jwt api laravel
PHP Laravel