/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

2 votes189 views2 answers
Brew switch php version
PHP
2 votes263 views3 answers
Laravel get query result as array
PHP
0 vote178 views1 answer
Wordpress wp_enqueue_script footer
PHP
0 vote232 views1 answer
How can we check in the table in comma separated values in laravel
PHP
61 votes210 views6 answers
Php random
PHP
0 vote170 views1 answer
Update php version in docker container
PHP
11 votes299 views6 answers
Redirect route with parameters laravel
PHP Laravel
0 vote183 views1 answer
Session_regenerate_id
PHP
0 vote171 views1 answer
How to play sound with php
PHP
3 votes176 views3 answers
Php remove everything after character
PHP