/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

-1 vote346 views1 answer
Return true false laravel
PHP Laravel
1 vote378 views2 answers
Laravel get data from request
PHP Laravel
4 votes333 views5 answers
Laravel array_pluck
PHP Laravel
0 vote403 views1 answer
Laravel get file to browser send
PHP Laravel
7 votes299 views2 answers
Laravel encrypt database fields
PHP Laravel
0 vote437 views1 answer
Laravel collection min
PHP Laravel
0 vote388 views1 answer
Check mobile or email in laravel
PHP Laravel
0 vote370 views1 answer
Laravel override eloquent all function
PHP Laravel
22 votes398 views5 answers
Get logged user id laravel
PHP Laravel
10 votes408 views4 answers
Print last query laravel
PHP Laravel