/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

7 votes219 views6 answers
Laravel validation unique email
PHP Laravel
1 vote211 views2 answers
How set field after another field in migration in laravel
PHP Laravel
0 vote220 views1 answer
Str not found laravel
PHP Laravel
11 votes223 views5 answers
Laravel model transaction
PHP Laravel
10 votes181 views2 answers
Laravel migration default value not working
PHP Laravel
0 vote209 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
-1 vote220 views1 answer
Laravel hide columns
PHP Laravel
1 vote251 views1 answer
Validation not exists with this id laravel
PHP Laravel
-1 vote236 views1 answer
Excel extract date from dd mm yyyy laravel blade
PHP Laravel
1 vote297 views1 answer
Clear bootstrap cache laravel
PHP Laravel