/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 votes141 views2 answers
Public_path laravel
PHP Laravel
1 vote135 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
1 vote121 views2 answers
Add laravel sail build as alias
PHP
20 votes130 views6 answers
Array random php
PHP
31 votes114 views6 answers
Php difference between two dates
PHP
16 votes135 views6 answers
Php get first key of array
PHP
0 vote126 views1 answer
Laravel event generate
PHP Laravel
5 votes113 views3 answers
Laravel destroy session
PHP
3 votes177 views2 answers
Laravel create project thorugh composer
PHP Laravel
19 votes130 views6 answers
Laravel Route Group
PHP Laravel