/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

13 votes175 views4 answers
Laravel login by id
PHP Laravel
3 votes192 views6 answers
Add to collection laravel
PHP Laravel
1 vote202 views1 answer
Types of looping directives in laravel
PHP Laravel
1 vote182 views2 answers
Get ip address in laravel
PHP Laravel
1 vote195 views1 answer
How to insert multiple data at a time with create method in laravel
PHP Laravel
1 vote179 views1 answer
Laravel active route check
PHP Laravel
40 votes188 views6 answers
Laravel create migration
PHP Laravel
1 vote194 views1 answer
Kill laravel server
PHP Laravel
0 vote217 views1 answer
Laravel custom abort message
PHP Laravel
0 vote181 views1 answer
Running laravel project in mobile phone
PHP Laravel