/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 vote349 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
0 vote292 views1 answer
Generate slug on create laravel
PHP Laravel
0 vote281 views1 answer
Editing items in collection in laravel
PHP Laravel
2 votes311 views3 answers
Add data to the collection laravel
PHP Laravel
38 votes228 views2 answers
Create request laravel command
PHP Laravel
36 votes269 views6 answers
Laravel 8 foreign key migration
PHP Laravel
0 vote324 views1 answer
How to use union and intersection in laravel query
PHP Laravel
0 vote298 views1 answer
Get post data in laravel
PHP Laravel
1 vote295 views1 answer
Laravel model created_at format edit
PHP Laravel
3 votes299 views2 answers
Laravel tinker update password
PHP Laravel