/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 vote141 views1 answer
Laravel get query in normal sql without bindings
PHP Laravel
0 vote135 views1 answer
Target class admin homecontroller does not exist laravel 8
PHP Laravel
0 vote141 views2 answers
Sortbydesc on a collection laravel
PHP Laravel
0 vote136 views1 answer
How to login laravel passport with postman
PHP Laravel
0 vote139 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP Laravel
18 votes143 views5 answers
If else statement in laravel blade
PHP Laravel
3 votes153 views2 answers
Return last inserted id in laravel
PHP Laravel
0 vote134 views1 answer
Laravel php 8 ububtu
PHP Laravel
14 votes160 views6 answers
Update query in laravel eloquent
PHP Laravel
5 votes154 views2 answers
Laravel 8 routes namespace
PHP Laravel