/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 vote191 views1 answer
Wordpress add block from single.php
PHP
2 votes210 views3 answers
Multiple primary key defined laravel
PHP Laravel
33 votes183 views6 answers
Post php
PHP
4 votes224 views1 answer
How to check query execution time in laravel
PHP Laravel
1 vote202 views3 answers
Create new laravel project with specific version
PHP Laravel
0 vote199 views3 answers
The `php` command cannot be found. Please verify that PHP is installed, or set the `php.executables` setting.
PHP
2 votes255 views1 answer
Laravel generate env
PHP Laravel
5 votes190 views1 answer
Laravel model method like foreach parts of
PHP
0 vote246 views1 answer
How to get shop page url in wordpress
PHP Wordpress
0 vote202 views1 answer
Prety php
PHP