/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 vote145 views1 answer
Laravel create project with auth 2021
PHP Laravel
3 votes155 views1 answer
Laravel send post request from controller
PHP Laravel
1 vote105 views1 answer
Laravel database procedures
PHP Laravel
1 vote163 views2 answers
Laravel 8
PHP Laravel
2 votes163 views3 answers
How get file size in laravel
PHP Laravel
10 votes159 views6 answers
Format time laravel
PHP Laravel
3 votes169 views3 answers
Pluck array in laravel
PHP Laravel
0 vote159 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP Laravel
3 votes155 views2 answers
Laravel first or fail
PHP Laravel
3 votes138 views1 answer
Php extensions for laravel
PHP Laravel