Get formatting style

[ianninirojas]

Hi, I want to know if it is possible to get a formatted value when importing an excel, for example there are two types of number format in my excel one with $ symbol and another with %.

[patrickbrouwers]

There's a WithFormatData concern

[patrickbrouwers]

Can you try to set https://github.com/SpartnerNL/Laravel-Excel/blob/3.1/config/excel.php#L88 to false. It might be that PhpSpreadsheet gets the formatting code that way.

[ianninirojas]

it worked, thanks!!!

[ianninirojas]

@patrickbrouwers another question Is it possible to get the cell style as the background color when importing a file?

[patrickbrouwers]

I think you can access it via OnEachRow. Otherwise you'll have to use a before sheet event and store the colors in a class property so you can access them later on

[ianninirojas]

awesome, thanks!