/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 vote322 views1 answer
Laravel echo html
PHP Laravel
4 votes253 views3 answers
Time now with milliseconds php
PHP
0 vote239 views1 answer
Auth.php Class "\App\User" not found
PHP
6 votes238 views3 answers
Disable foreign key laravel
PHP
0 vote249 views1 answer
Mr deepfakes forum
PHP
0 vote257 views1 answer
Livewire call another component
PHP
11 votes294 views2 answers
How login one user with id in laravel
PHP Laravel
1 vote305 views3 answers
Display pdf file in laravel
PHP Laravel
3 votes246 views1 answer
DB::raw('SUM(subtotal) as total sales', 'SUM(discount) as d')
PHP
0 vote254 views1 answer
Php options list view sidebar (240 x 500), list view results (600 x 180), listing page (450 x 200)
PHP