/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

16 votes383 views3 answers
Laravel make model along with its controller and migration file
PHP Laravel
8 votes297 views4 answers
In_array()
PHP
0 vote304 views1 answer
Php postgresql number of rows
PHP
1 vote377 views1 answer
Laravel add timestamps to existing table
PHP
0 vote341 views1 answer
Twig superglobal get
PHP
15 votes455 views6 answers
Add shortcode in wordpress
PHP Wordpress
2 votes333 views2 answers
How to prevent Browser cache for php site
PHP
34 votes341 views6 answers
Php random number generator
PHP
11 votes330 views4 answers
Remove .php htaccess
PHP
0 vote344 views2 answers
Db($twoRandomPhotosOfSomePeoples);
PHP