/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

0 vote175 views1 answer
Use s3 storage laravel
PHP
1 vote151 views2 answers
Laravel validate video
PHP
4 votes154 views2 answers
Date_default_timezone_set for india in php laravel
PHP
0 vote178 views1 answer
Woocommerce Display field value on the admin order edit page [Custom Field Display 2]
PHP
0 vote181 views2 answers
Mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
PHP
31 votes177 views6 answers
Update or create laravel
PHP Laravel
0 vote150 views1 answer
Laravel connection timed out
PHP
0 vote234 views1 answer
How to add watermark in FPDF PHP - Parte 2
PHP
2 votes202 views2 answers
Laravel blade auth check
PHP Laravel
0 vote183 views1 answer
Yii app db createcommand join yii1
PHP