/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

12 votes166 views4 answers
Laravel auth setup
PHP Laravel
8 votes176 views5 answers
Laravel route model binding
PHP Laravel
0 vote117 views1 answer
How to store multiple value in session in laravel
PHP Laravel
0 vote190 views2 answers
Laravel auth login with phone or email
PHP Laravel
0 vote163 views1 answer
Foreign key cosntraint laravel
PHP Laravel
0 vote162 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
29 votes187 views6 answers
Laravel timestamp
PHP Laravel
1 vote164 views1 answer
Laravel not finding asset files in public directory
PHP Laravel
9 votes186 views5 answers
Laravel exist
PHP Laravel
0 vote178 views1 answer
Illuminate\contracts\container\bindingresolutionexception: target class laravel 8
PHP Laravel