/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

7 votes134 views2 answers
Transaction commit rollback in laravel
PHP Laravel
3 votes131 views2 answers
Laravel check if query builder is empty
PHP Laravel
3 votes133 views1 answer
Get soft deleted data laravel
PHP Laravel
0 vote110 views1 answer
Laravel doesn't work update
PHP Laravel
0 vote136 views2 answers
How change default value for enum colun in laravel
PHP Laravel
1 vote144 views2 answers
Laravel route group middleware prefix
PHP Laravel
1 vote132 views1 answer
Publishing laravel module package
PHP Laravel
3 votes182 views3 answers
Loop index foreach laravel
PHP Laravel
7 votes127 views1 answer
Laravel if syntax
PHP Laravel
1 vote124 views1 answer
Config clear laravel
PHP Laravel