/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 vote247 views2 answers
Request get query string laravel
PHP Laravel
0 vote180 views1 answer
Country code validation in laravel
PHP Laravel
18 votes246 views6 answers
Laravel rename table
PHP Laravel
1 vote238 views4 answers
Laravel assign active based on route name
PHP Laravel
1 vote260 views1 answer
Laravel mongodb delete
PHP Laravel
1 vote198 views3 answers
Delete a migration laravel
PHP Laravel
0 vote282 views1 answer
Db connection postgres laravel
PHP Laravel
0 vote199 views1 answer
Uncaught Error: Class 'Illuminate\Foundation\Application' in laravel bootstrap
PHP Laravel
12 votes303 views3 answers
Validation.required laravel
PHP Laravel
5 votes196 views5 answers
Laravel composer update
PHP Laravel