/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

0 vote139 views2 answers
Laravel apiresource
PHP Laravel
1 vote148 views1 answer
Why storage link do not work in host for laravel
PHP Laravel
2 votes142 views3 answers
Laravel many to many relationship with pivot table
PHP Laravel
0 vote142 views1 answer
Laravel create table with model command line
PHP Laravel
0 vote141 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
0 vote171 views1 answer
Tinyinteger laravel +size
PHP Laravel
0 vote150 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
0 vote185 views1 answer
Show data as per url slug change in laravel
PHP Laravel
0 vote131 views1 answer
Laravel datatable columnDefs
PHP Laravel
0 vote100 views1 answer
Laravel foreach localstorage
PHP Laravel