/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

13 votes170 views6 answers
Laravel manually authenticate user
PHP Laravel
0 vote205 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
0 vote176 views1 answer
Configuration laravel dompdf
PHP Laravel
0 vote183 views1 answer
Laravel npm run dev mix error FIX
PHP Laravel
3 votes181 views1 answer
Laravel eloquent increment
PHP Laravel
15 votes182 views6 answers
Confirm password validation in laravel
PHP Laravel
0 vote184 views1 answer
Post with count greater than 1 laravel
PHP Laravel
1 vote194 views1 answer
Laravel password verification
PHP Laravel
45 votes180 views6 answers
Laravel outer join
PHP Laravel
1 vote170 views1 answer
Protected gaurded in laravel
PHP Laravel