/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 vote271 views2 answers
Check method in laravel
PHP Laravel
1 vote324 views2 answers
Get ip in laravel
PHP Laravel
0 vote272 views2 answers
Laravel bootstrap nav active
PHP Laravel
0 vote287 views1 answer
Laravel file custom name
PHP Laravel
0 vote240 views1 answer
Laravel with eager where
PHP Laravel
11 votes251 views3 answers
Laravel running a specific migration on different path
PHP Laravel
0 vote296 views4 answers
Join table laravel count
PHP Laravel
0 vote267 views1 answer
Laravel Http client throw exception if request is not successful
PHP Laravel
4 votes246 views4 answers
Laravel add request
PHP Laravel
15 votes259 views3 answers
Laravel setup auth
PHP Laravel