/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 vote272 views1 answer
Laravel response download video laravel medialibrary
PHP Laravel
26 votes294 views6 answers
Laravel migration rollback
PHP Laravel
0 vote300 views2 answers
Add blade in blade laravel
PHP Laravel
4 votes311 views2 answers
Switch in laravel
PHP Laravel
0 vote282 views1 answer
Laravel parse markdown
PHP Laravel
3 votes313 views5 answers
How to create slug in laravel
PHP Laravel
0 vote287 views1 answer
Laravel share
PHP Laravel
2 votes246 views1 answer
Comments table example in laravel
PHP Laravel
0 vote295 views1 answer
Laravel collection pop
PHP Laravel
0 vote329 views1 answer
Count number of rows laravel controller
PHP Laravel