/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 vote180 views1 answer
$this meaning in codeigniter
PHP CodeIgniter
0 vote171 views1 answer
Laravel where between cluse
PHP Laravel
8 votes156 views3 answers
Eloquent using last()
PHP
0 vote139 views1 answer
Increase php_values
PHP
0 vote206 views1 answer
Php-oop
PHP
0 vote161 views1 answer
Php multi string to single string
PHP
0 vote156 views1 answer
How get query logs in laravel
PHP Laravel
0 vote142 views1 answer
Throw 403 laravel
PHP
12 votes182 views2 answers
Get current authenticated user laravel
PHP Laravel
4 votes160 views2 answers
Array filter use key
PHP