/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 vote166 views1 answer
Multiple slug in route
PHP
5 votes213 views2 answers
Memory limit wordpress
PHP Wordpress
0 vote168 views2 answers
Laravel model column default value
PHP
1 vote159 views1 answer
WordPress asking for FTP credentials on localhost
PHP
2 votes185 views1 answer
Get woocommerce order details Object
PHP
0 vote187 views1 answer
Symfony retun json
PHP Symfony
0 vote216 views1 answer
Applying multiple order by in codeigniter
PHP CodeIgniter
0 vote166 views1 answer
Symfony see all make command
PHP
1 vote171 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) in phar://D:/Program Files/Composer - PHP/composer.phar/src/Composer/DependencyResolver/Solver.php on line 223
PHP
0 vote177 views1 answer
Show float laravel blade
PHP