/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 vote192 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP Laravel
1 vote229 views1 answer
Laravel eloquent get only field name
PHP Laravel
13 votes190 views6 answers
Laravel migration change column type
PHP Laravel
6 votes189 views4 answers
Enset laravel session
PHP Laravel
7 votes229 views3 answers
Get table name from model laravel
PHP Laravel
0 vote216 views1 answer
Custom timestamp column laravel
PHP Laravel
5 votes211 views4 answers
Laravel collection merge
PHP Laravel
48 votes196 views5 answers
Laravel clear route cache
PHP Laravel
0 vote205 views1 answer
How to change laravel logo image
PHP Laravel
0 vote285 views1 answer
Laravel one session per user
PHP Laravel