/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 vote216 views1 answer
Laravel permission spatie cache clear
PHP Laravel
0 vote199 views1 answer
Call variable from inside a collection laravel
PHP Laravel
0 vote192 views1 answer
@method overide form laravel
PHP Laravel
1 vote194 views2 answers
How set field after another field in migration in laravel
PHP Laravel
0 vote207 views1 answer
Laravel migration type to store html
PHP Laravel
0 vote187 views1 answer
Pass variable in laravel ancher tag laravel 8
PHP Laravel
1 vote191 views3 answers
Print query statement in laravel
PHP Laravel
3 votes159 views1 answer
Eloquent first
PHP Laravel
0 vote268 views1 answer
Laravel deleted controller still cached
PHP Laravel
0 vote196 views1 answer
Laravel replace white space with dash
PHP Laravel