/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

2 votes156 views1 answer
Proper permission webserver laravel
PHP Laravel
15 votes152 views3 answers
Laravel setup auth
PHP Laravel
0 vote151 views1 answer
How to call function in blade laravel
PHP Laravel
0 vote151 views1 answer
Laravel filesystem link
PHP Laravel
6 votes179 views3 answers
Laravel ide helper
PHP Laravel
0 vote159 views1 answer
Laravel chain query builder
PHP Laravel
1 vote163 views2 answers
Redirect::route('profile') and with() in laravel
PHP Laravel
0 vote157 views1 answer
Show selected value in dropdown laravel
PHP Laravel
0 vote151 views1 answer
Laravel face-auth
PHP Laravel
0 vote156 views2 answers
String to array in laravel
PHP Laravel