/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

1 vote335 views1 answer
Laravel cashier overwrite users table name
PHP Laravel
8 votes335 views3 answers
Laravel 8 check if record exists
PHP Laravel
0 vote366 views1 answer
Laravel API Endpoint "401 Unauthorized" on Server But Works Fine On Localhost
PHP Laravel
0 vote311 views2 answers
Foreach limit laravel
PHP Laravel
0 vote312 views1 answer
Call to a member function delete() on null laravel 8
PHP Laravel
0 vote283 views4 answers
Findmany laravel
PHP Laravel
0 vote315 views2 answers
Laravel pagination vuetify
PHP Laravel
17 votes306 views6 answers
Laravel auth user in constructor
PHP Laravel
5 votes341 views3 answers
Laravel if request has
PHP Laravel
0 vote318 views1 answer
Load differenet .env file in laravel
PHP Laravel