/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

8 votes292 views2 answers
Laravel passport
PHP Laravel
1 vote306 views2 answers
Laravel route group middleware prefix
PHP Laravel
0 vote318 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP Laravel
0 vote309 views1 answer
Set custome table laravel eloquent
PHP Laravel
2 votes269 views2 answers
Laravel dump
PHP Laravel
10 votes319 views3 answers
Check count in laravel
PHP Laravel
2 votes239 views1 answer
Comments table example in laravel
PHP Laravel
1 vote324 views1 answer
$posts- links() laravel design error
PHP Laravel
3 votes298 views1 answer
Laravel carbon get year number
PHP Laravel
1 vote312 views1 answer
Laravel failed jobs retry
PHP Laravel