/PHP/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 vote309 views2 answers
Php get duplicate keys in array without using inbuilt function
PHP
0 vote309 views2 answers
Laravel sortby varchar date
PHP
0 vote308 views1 answer
On running php file showing code instead of view
PHP
2 votes364 views1 answer
Add Laravel .env variable to Vue component
PHP Laravel
3 votes289 views3 answers
Php array to csv
PHP
1 vote297 views1 answer
Add dd function composer
PHP
3 votes347 views1 answer
Laravel validation pdf
PHP Laravel
0 vote291 views1 answer
Php show number 4 digit
PHP
2 votes297 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP
1 vote343 views1 answer
Add post meta wordpress
PHP