Skipping columns when importing (ie) CSV

[fruitl00p]

We're currently importing / parsing a CSV file with 100+ columns but only actually read 15 ... You can imagine the overhead of reading the whole row, knowingly throwing everything (but the 15 columns) away again ...

any idea of limiting the resultset?

[patrickbrouwers]

You could try a read filter

https://phpspreadsheet.readthedocs.io/en/latest/topics/reading-files/#reading-only-specific-columns-and-rows-from-a-file-read-filters

https://github.com/SpartnerNL/Laravel-Excel/blob/3.1/src/Concerns/WithReadFilter.php