/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 vote345 views1 answer
Return single row from eloquent all collection laravel
PHP Laravel
2 votes303 views2 answers
Laravel whereIn example
PHP Laravel
0 vote333 views2 answers
Laravel log could not be opened fix
PHP Laravel
1 vote323 views1 answer
Cart::total return number format value laravel
PHP Laravel
19 votes334 views5 answers
Php artisan auth in laravel 8
PHP Laravel
0 vote308 views1 answer
Laravel collection pull
PHP Laravel
0 vote326 views1 answer
Php laravel rount price to 99
PHP Laravel
1 vote367 views1 answer
Edit data using model in laravel 8
PHP Laravel
42 votes349 views5 answers
Laravel create controller command
PHP Laravel
0 vote349 views2 answers
Laravel migration change column order
PHP Laravel