/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 vote169 views1 answer
Laravel display old value in form
PHP Laravel
0 vote180 views1 answer
Call to a member function delete() on null laravel 8
PHP Laravel
8 votes166 views2 answers
Laravel hash namespace
PHP Laravel
0 vote182 views4 answers
Installing bootstrap on laravel8
PHP Laravel
4 votes175 views2 answers
Laravel collection random
PHP Laravel
0 vote186 views1 answer
Laravel permission spatie cache clear
PHP Laravel
0 vote182 views1 answer
Prevent xss attack in laravel
PHP Laravel
1 vote168 views2 answers
Laravel make directory
PHP Laravel
2 votes169 views4 answers
Cors laravel
PHP Laravel
2 votes178 views3 answers
Laravel migration drop foreign keys
PHP Laravel