/PHP/Laravel/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 vote104 views1 answer
Laravel collection diff
PHP Laravel
2 votes104 views1 answer
Laravel string key
PHP Laravel
3 votes114 views5 answers
How to create slug in laravel
PHP Laravel
5 votes106 views1 answer
Laravel route required parameters
PHP Laravel
7 votes112 views3 answers
Get table name from model laravel
PHP Laravel
0 vote105 views1 answer
Remove public or index file from url in laravel
PHP Laravel
0 vote112 views1 answer
Laravel blade get array count in Blade
PHP Laravel
0 vote114 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
0 vote107 views2 answers
How to get just the first row from a table in laravel
PHP Laravel
0 vote121 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP Laravel