/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

18 votes370 views4 answers
Laravel create model controller and migration on line
PHP Laravel
13 votes304 views6 answers
Laravel array validation
PHP Laravel
13 votes374 views6 answers
How to create model in laravel
PHP Laravel
12 votes304 views3 answers
For else laravel
PHP Laravel
0 vote328 views1 answer
Laravel looping checking if last record has reached
PHP Laravel
8 votes340 views5 answers
Laravel route model binding
PHP Laravel
3 votes347 views2 answers
How to use required_with in laravel to array element
PHP Laravel
0 vote367 views1 answer
Laravel make:action
PHP Laravel
6 votes349 views4 answers
Laravel base url
PHP Laravel
4 votes306 views5 answers
Laravel array_pluck
PHP Laravel