Export the phone number with country code to the excel become the formula | maatwebsite | excel | Laravel | PHP

Question

I am working on the Laravel application where I export the information of the client to excel by using the maatwebsite/excel package.

Everything is working as expected. But when I start to export the client's phone number with country code(which obviously includes the plus symbol) the value under the excel field becomes the formula section.

ClientsExport.php

class ClientsExport implements FromCollection, WithHeadings, WithMapping, WithColumnFormatting
{
    // ...
    public function headings(): array
    {
        return [
            'Name',
            'Identification type',
            'Tax ID',
            'Email',
            'Address',
            'Country',
            'Department',
            'Zip',
            'Fax',
            'Phone',
            'Mobile',
            'Date'
        ];
    }

    public function columnFormats(): array
    {
        return [
            'H' => 0,
            'I' => 0,
            'J' => '@',
            'K' => '@',
            'L' => NumberFormat::FORMAT_DATE_DDMMYYYY,
        ];
    }
    // ...
}

I even try both general and text format(i.e 'General' or '@') but still have the same error. Field J and K have phone and mobile value respectively.

The data is export to the excel file. I think this is the default behavior of the excel file i.e when we click on the field value which prefix with a plus symbol then it automatically becomes the formula bar section.

Can I get rid of it and change the behavior? Thanx in advance.

Answer 1

等待大神答复