/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 votes266 views2 answers
Laravel drop multiple columns
PHP Laravel
12 votes193 views3 answers
Call controller function from another controller laravel
PHP Laravel
2 votes191 views1 answer
Base64 encode laravel
PHP Laravel
0 vote219 views6 answers
Socialite laravel 7
PHP Laravel
0 vote277 views1 answer
Laravel 8 model filter
PHP Laravel
0 vote192 views1 answer
Appserviceprovider laravel auth user
PHP Laravel
5 votes241 views2 answers
Laravel mail send
PHP Laravel
0 vote221 views1 answer
Edit items in Laravel collection
PHP Laravel
0 vote186 views1 answer
Return view inside subfolder laravel
PHP Laravel
-1 vote171 views4 answers
Laravel collection find
PHP Laravel