How to export with "+" begging number, NumberFormat::FORMAT_GENERAL doesn't use

[MIKOTO123]

`/**
* @return mixed
*/
public function array(): array
{

    $export_arr[0] = [
        '1233',
        'smgui@zzy.cn',
        '+152231312313',
    ];
    return $export_arr;
}

public function headings(): array
{
    return [
        'row',
        'mail',
        'mobile',
    ];
}

public function columnFormats(): array
{
    return [
        'C' => NumberFormat::FORMAT_GENERAL,
    ];
}

`
result:

row	mail	mobile
1233	smgui@zzy.cn	152231312313

I just want to keep the + sign,like :

row	mail	mobile
1233	smgui@zzy.cn	+152231312313

[patrickbrouwers]

You'll have to create your own value binder (https://docs.laravel-excel.com/3.1/exports/column-formatting.html#value-binders), check if it's a phone number and set the value explicit as string (DataType::TYPE_STRING).

[MIKOTO123]

You'll have to create your own value binder (https://docs.laravel-excel.com/3.1/exports/column-formatting.html#value-binders), check if it's a phone number and set the value explicit as string (DataType::TYPE_STRING).

Doesn't it solve by WithColumnFormatting?.I think this is more reasonable and easy.
Anyway, thank you very much.I solve it by what you said.

[patrickbrouwers]

ColumnFormatting isn't the same as data types in PhpSpreadsheet. Column format is the format that Excel uses, data type is how PhpSpreadsheet formats the value before inserting it in the Excel.

[MIKOTO123]

ColumnFormatting isn't the same as data types in PhpSpreadsheet. Column format is the format that Excel uses, data type is how PhpSpreadsheet formats the value before inserting it in the Excel.

Ok,I got it.Thank you.

[fwilliamconceicao]

You'll have to create your value binder (https://docs.laravel-excel.com/3.1/exports/column-formatting.html#value-binders), check if it's a phone number and set the value explicit as a string (DataType::TYPE_STRING).

I just did that and excel, CSV and any kind program of a spreadsheet is interpreting my column and cells as numbers and not general strings which are giving me a lot of trouble because some dates are removing the leading zero from days and values the suffix zeros.

[kelenakamura]

how do you set a column format to a text column? will that auto prepend a single quote into the field?