/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 vote227 views1 answer
Combine 2 columns search query laravel
PHP Laravel
0 vote208 views1 answer
Add variables to line in laravel notification
PHP Laravel
0 vote221 views1 answer
Laravel get only validated data
PHP Laravel
1 vote211 views1 answer
Forenkey set inlaravel 8
PHP Laravel
43 votes242 views6 answers
Laravel cache
PHP Laravel
1 vote203 views1 answer
Laravel server sent events
PHP Laravel
0 vote198 views1 answer
Laravel 8 crud api example
PHP Laravel
0 vote228 views1 answer
Laravel Can't write image data to path Image::make($image)->resize
PHP Laravel
9 votes277 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel
0 vote198 views2 answers
Laravel logout all users
PHP Laravel