/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 vote327 views1 answer
Laravel collection tap
PHP Laravel
0 vote345 views2 answers
Add blade in blade laravel
PHP Laravel
2 votes357 views1 answer
Laravel catch exception ex log save
PHP Laravel
6 votes341 views2 answers
Laravel check if request has value
PHP Laravel
0 vote388 views2 answers
Laravel composer sanctum
PHP Laravel
0 vote360 views1 answer
Optimistic Locking Laravel
PHP Laravel
0 vote328 views1 answer
How convert the string to int in laravel function event
PHP Laravel
0 vote394 views1 answer
What is actullay work model in laravel
PHP Laravel
50 votes475 views6 answers
Laravel add column to table
PHP Laravel
0 vote361 views1 answer
Italic text in laravel notification
PHP Laravel