/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 vote222 views1 answer
Laravel if file is image
PHP Laravel
8 votes283 views6 answers
Laravel transaction
PHP Laravel
2 votes222 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP Laravel
0 vote216 views1 answer
Laravel carbon first day of month
PHP Laravel
6 votes301 views2 answers
Laravel migration integer
PHP Laravel
1 vote269 views1 answer
Autoload file in laravel
PHP Laravel
1 vote235 views1 answer
Laravel get last get request
PHP Laravel
0 vote242 views4 answers
Date format change in laravel blade
PHP Laravel
0 vote246 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
2 votes217 views1 answer
Laravel where update query
PHP Laravel