Performace XLSX

Welcome Forums General PowerShell Q&A Performace XLSX

This topic contains 1 reply, has 2 voices, and was last updated by

 
Participant
3 years, 3 months ago.

  • Author
    Posts
  • #27375

    Participant
    Points: 0
    Rank: Member

    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

    Participant
    Points: 0
    Rank: Member

    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

The topic ‘Performace XLSX’ is closed to new replies.