/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

8 votes340 views6 answers
Laravel validation date
PHP
2 votes319 views2 answers
Php get epoch timestamp of date
PHP
0 vote363 views2 answers
Get page title, excerpt or content by id
PHP
0 vote327 views1 answer
How To Unset Or Delete An Element From Array By Value In PHP?
PHP
2 votes357 views2 answers
How to add property to an object in php
PHP
0 vote363 views1 answer
Laravel create mode
PHP
0 vote342 views1 answer
Curlopt_postfields php example
PHP
0 vote451 views1 answer
Share wordpress post on whatsapp without plugin
PHP Wordpress
0 vote326 views1 answer
String lenghth
PHP
0 vote266 views1 answer
Php warning: php startup: unable to load dynamic library 'bz2' (tried: \xampp\php\ext\bz2 (the specified module could not be found), \xampp\php\ext\php_bz2.dll (the specified module could not be found)) in unknown on line 0
PHP