HeadingRowFormatter : deal with éèà characters in header's labels

[invaders-xx]

Hi,

I have a CSV file with heading containing characters such as "éèà". I created a custom HeadingRowFormatter which do ->lower()->slug() but those headings are empty when doing a (new HeadingRowImport()).

Any ideas why and how to handle as I don't have any control on the content of those headers.

Many thanks in advance for your help

[patrickbrouwers]

You can set the a new default by using HeadingRowFormatter::default('custom') before you call HeadingRowImport

[patrickbrouwers]

Assuming you've cleared a possible config cache, HeadingRowImport will use the formatter you configured in the config: https://github.com/SpartnerNL/Laravel-Excel/blob/3.1/src/HeadingRowImport.php#L50 / https://github.com/SpartnerNL/Laravel-Excel/blob/3.1/src/Imports/HeadingRowFormatter.php#L85

[invaders-xx]

I cleared my cache, I can see that heading are going through the formatter, but each time the header contains any "éàè", the result is empty

[patrickbrouwers]

Best to PR a failing test to demonstrate the behaviour, I'm not sure on which side it goes wrong then.

[invaders-xx]

I changed encoding in config from UTF-8 to ISO-8859-1 and it works. I would like to keep UTF-8 encoding in config, is there a way to specify the encoding in HeadingRowImport?

[patrickbrouwers]

You can always create your own HeadingRowImport (or extend it) and enable the custom encoding there