/PHP/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

1 vote116 views2 answers
Load session in codeigniter
PHP
-1 vote150 views2 answers
How to pass value from one php page to another using session
PHP
6 votes159 views3 answers
Disable foreign key laravel
PHP Laravel
1 vote137 views2 answers
Php new stdClass object
PHP
5 votes182 views3 answers
Delete all rows in table laravel foreign key
PHP
0 vote136 views1 answer
How to get post by comment in laravel
PHP
16 votes144 views1 answer
League/omnipay v3.0.0 requires php ^7.1 -> your php version (8.0.11) does not satisfy that requirement
PHP
0 vote189 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP
0 vote161 views2 answers
Laravel dirty words check
PHP Laravel
2 votes163 views2 answers
Check if date between two dates laravel
PHP Laravel