/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

9 votes174 views4 answers
Laravel group route controller
PHP Laravel
0 vote167 views1 answer
Import local js file laravel
PHP Laravel
0 vote178 views1 answer
Onclick call route laravel
PHP Laravel
0 vote163 views1 answer
Laravel new line in session flash message
PHP Laravel
0 vote165 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP Laravel
0 vote181 views1 answer
Create a button add in laravel
PHP Laravel
0 vote175 views1 answer
Laravel display the date the participation was created
PHP Laravel
0 vote159 views1 answer
Action after model is created laravel
PHP Laravel
-1 vote171 views2 answers
String and number laravel faker
PHP Laravel
0 vote159 views1 answer
Json whereIn laravel
PHP Laravel