/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 vote116 views2 answers
Laravel collection intersect
PHP Laravel
7 votes128 views2 answers
Laravel field types from database field type
PHP Laravel
-2 votes120 views2 answers
Carbon laravel d m y to y-m-d
PHP Laravel
-1 vote110 views1 answer
Laravel migration table bigint
PHP Laravel
4 votes126 views2 answers
Laravel migration update table column type
PHP Laravel
22 votes138 views5 answers
Get logged user id laravel
PHP Laravel
3 votes119 views2 answers
What is the use of migration file in laravel
PHP Laravel
1 vote121 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
4 votes113 views4 answers
Chunk in laravel
PHP Laravel
4 votes121 views3 answers
Laravel use config
PHP Laravel