/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

0 vote285 views1 answer
How to display the responce of curl in php
PHP
0 vote342 views1 answer
Get the user detail inside the constructor Laravel
PHP Laravel
2 votes326 views3 answers
Format date laravel timestamp view
PHP Laravel
3 votes288 views2 answers
Laravel route multiple methods
PHP
0 vote345 views1 answer
Adding another return message from Laravel Livewire
PHP Laravel
5 votes288 views2 answers
Laravel - Send mail using mail class
PHP
-1 vote277 views1 answer
Get the url without the query string php
PHP
4 votes307 views4 answers
Php pretty print
PHP
0 vote294 views1 answer
Faker instance in tinker
PHP
17 votes281 views4 answers
Foreach ph
PHP