/PHP/Laravel/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 votes122 views1 answer
Use str laravel
PHP Laravel
0 vote125 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP Laravel
2 votes134 views1 answer
Laravel model quard
PHP Laravel
0 vote128 views1 answer
Laravel route contains particular segment
PHP Laravel
15 votes121 views6 answers
Laravel create request
PHP Laravel
2 votes185 views3 answers
Call stored procedure in laravel
PHP Laravel
0 vote132 views1 answer
Create or update laravel 5.8 stackoverflow
PHP Laravel
7 votes133 views2 answers
Date time format for laravel validation
PHP Laravel
0 vote128 views1 answer
Laravel Http client throw exception if request is not successful
PHP Laravel
0 vote129 views1 answer
Laravel check if form has errors
PHP Laravel