/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

4 votes106 views1 answer
Connection failed: could not find driver php
PHP
0 vote126 views1 answer
No Privileges to create databases phpmyadmin
PHP
1 vote128 views2 answers
Laravel, return view with Request::old
PHP Laravel
0 vote116 views1 answer
Php artisan down allow ip
PHP
43 votes127 views10 answers
API
PHP
26 votes169 views6 answers
Php get date between two dates
PHP
31 votes127 views6 answers
Php get client ip
PHP
0 vote103 views1 answer
How to get event dates on change in datetimepicker with laravel livewire
PHP Laravel
6 votes123 views3 answers
Date_default_timezone_set(): timezone id
PHP
0 vote127 views1 answer
Php get header language
PHP