Is there a multithreaded way to read all data from a single-sheet XLSX file?
Currently I’m using the PsExcel module and doing a simple
$fileData = import-Excel -Path $Path
But the file I’m reading from has 16,000 rows and nearly 40 columns. If I specify that I only want columns 0-9, it still takes at least 3 minutes. If it were a CSV, I wouldn’t have this issue.
What’s the best route for tackling this problem?