Performace XLSX

This topic contains 1 reply, has 2 voices, and was last updated by  Richard Siddaway 2 years, 4 months ago.

  • Author
    Posts
  • #27375

    PowerShell84
    Participant

    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?

    Thanks

  • #27381

    Richard Siddaway
    Moderator

    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

You must be logged in to reply to this topic.