/PHP/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

2 votes235 views2 answers
Get all sort by laravel
PHP Laravel
0 vote263 views1 answer
Model find by certain column laravel
PHP Laravel
0 vote238 views1 answer
Php array_push in foreach duplicate
PHP
0 vote212 views0 answer
Laravel
PHP Laravel
0 vote221 views1 answer
Laravel route match
PHP Laravel
4 votes205 views1 answer
Laravel add utility class
PHP
3 votes315 views6 answers
Jwt laravel
PHP Laravel
1 vote210 views1 answer
Laravel queue work schedule cpanel
PHP Laravel
13 votes243 views6 answers
How to run laravel project
PHP
1 vote196 views1 answer
Php konstanten
PHP