/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 vote151 views2 answers
Where are WordPress Pages and Posts Stored
PHP
0 vote165 views3 answers
Serialise php
PHP
1 vote161 views1 answer
Function in first collection laravel
PHP Laravel
1 vote157 views1 answer
Laravel 8: seed users + Jetstream teams
PHP
0 vote171 views1 answer
Date format with t and z php
PHP
14 votes162 views6 answers
Install php 8 ubuntu
PHP
0 vote166 views2 answers
Display money format php
PHP
0 vote191 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
1 vote150 views1 answer
How to create a bot in telegram in php
PHP
0 vote186 views3 answers
Automatic get year for copyright html
PHP