/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

24 votes213 views6 answers
Validation error message in laravel
PHP Laravel
1 vote218 views4 answers
In_array validation laravel
PHP Laravel
1 vote224 views1 answer
Laravel export make comman
PHP Laravel
5 votes223 views3 answers
How get some parameter from request in laravel
PHP Laravel
1 vote216 views1 answer
Autoload file laravel
PHP Laravel
0 vote225 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
12 votes246 views2 answers
Get current authenticated user laravel
PHP Laravel
9 votes218 views3 answers
Pass variable to blade laravel
PHP Laravel
0 vote256 views3 answers
Database and files backup laravel
PHP Laravel
4 votes224 views3 answers
Ubuntu where are laravel logs stored
PHP Laravel