/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

1 vote213 views1 answer
Laravel realation with has
PHP Laravel
0 vote166 views2 answers
Xyz
PHP
0 vote209 views1 answer
Pl sql php connect
PHP
0 vote211 views1 answer
Laravel resourece type
PHP Laravel
47 votes263 views6 answers
How to add new column in laravel migration
PHP
-1 vote205 views2 answers
Best way to check if a URL is valid
PHP
1 vote230 views1 answer
Use model from variable laravel
PHP Laravel
14 votes172 views6 answers
Query builder
PHP
0 vote193 views1 answer
Test a single file laravel
PHP Laravel
1 vote219 views1 answer
Insert php variable css
PHP