/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

5 votes133 views2 answers
Laravel jetstream livewire
PHP Laravel
9 votes133 views6 answers
Laravel logout
PHP Laravel
1 vote126 views2 answers
Laravel add attribute to model
PHP Laravel
1 vote176 views4 answers
Laravel scheduler run
PHP Laravel
12 votes132 views2 answers
Timestamp false in laravel
PHP Laravel
0 vote135 views1 answer
Defining constant in config laravel
PHP Laravel
22 votes150 views6 answers
Log Laravel
PHP Laravel
1 vote126 views3 answers
Check table exists in db laravel
PHP Laravel
0 vote131 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel
1 vote149 views2 answers
How to validate video laravel
PHP Laravel