/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

3 votes118 views1 answer
Laravel validation greater than or equal to
PHP Laravel
0 vote108 views1 answer
Convert byte to megabyte php
PHP
4 votes95 views2 answers
Signup API in laravel
PHP
16 votes117 views6 answers
Confirm password validation laravel
PHP Laravel
1 vote91 views2 answers
Laravel route group middleware prefix
PHP
4 votes146 views2 answers
Validate year laravel
PHP Laravel
0 vote100 views1 answer
Symfony dump request headers
PHP
12 votes179 views6 answers
Email validation in laravel
PHP Laravel
2 votes98 views1 answer
Phpexcel set width
PHP
0 vote88 views1 answer
Prevent resubmition on page reload
PHP