/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 vote401 views1 answer
Data type for price in laravel
PHP Laravel
23 votes341 views6 answers
Laravel 8 route
PHP Laravel
37 votes409 views6 answers
Laravel create or update
PHP Laravel
0 vote339 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
1 vote376 views2 answers
How to get data from a table in laravel
PHP Laravel
0 vote387 views1 answer
How to get meta information from pagination in laravel controller
PHP Laravel
0 vote394 views1 answer
Laravel imap - Get message attachments
PHP Laravel
1 vote364 views1 answer
How convert the date and time to integer in laravel
PHP Laravel
44 votes332 views4 answers
Laravel random string
PHP Laravel
11 votes323 views3 answers
Laravel get last 5 records
PHP Laravel