/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

4 votes199 views2 answers
Laravel form method delete
PHP Laravel
4 votes213 views2 answers
How validate hash string in laravel
PHP Laravel
0 vote206 views1 answer
Laravel where search like with space
PHP Laravel
0 vote216 views1 answer
Populate old value of dropdown laravel
PHP Laravel
0 vote221 views1 answer
Laravel count group by date
PHP Laravel
2 votes215 views1 answer
Laravel https assets
PHP Laravel
2 votes221 views2 answers
Laravel migration alter column unique
PHP Laravel
0 vote251 views2 answers
How to use flash message in laravel
PHP Laravel
0 vote226 views1 answer
Laravel get mysql column datatype
PHP Laravel
2 votes215 views2 answers
The requested url was not found on this server. laravel
PHP Laravel