Performace XLSX

Hi Powershell,

I made convert multiple text files to multiple CSV files in powershell script and similarly, convert multiple text files to a single XLSX files.

Process of CSV reading is faster and really slow XLSX processing in powershell.
Why is XLSX file reading very slow in powerhsell?

Is there any way better?


Working directly with Excel spreadsheets has always been very slow in PowerShell. Its due to the way PowerShell works with the Excel COM objects. I’ve always recommended doing as much work as possible in a CSV file then reading that into Excel rather than trying to write directly into Excel.

PowerShell 5.0 has much improved COM support and is much faster. I’d try using that version if I was you