Powershell version 5's integraion with Excel

Welcome Forums General PowerShell Q&A Powershell version 5's integraion with Excel

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

3 years, 1 month ago.

  • Author
  • #32881

    Points: 0
    Rank: Member

    Hello Powershell gurus
    I am using powershell to create an excel worksheet and work wiith it. I will need to make report, which has a table and I require formatting the column headers etc. I have researched on internet, specifically the article :
    PowerShell and Excel: Adding Some Formatting To Your Report

    The problem with this is that border creation seems to be a very cumbersome process. While the powershell team has created out-html to print out reports very efficiently and conviniently, is the data output to excel been taken care of in powershell v5, or in any version?
    I would prefer a way to easily create a visually appealing table in an excel spreadsheet.
    Please share the code if possible.


  • #32887

    Points: 38
    Rank: Member

    I don't think it does borders yet but have a look at Doug Finke's Excel module. It makes getting data into and out of Excel very easy.

    Introducing the PowerShell Excel Module

  • #32891

    Points: 0
    Rank: Member

    Thanks for pointing in the right direction Matt. I will take a look if this module solves my purpose.

The topic ‘Powershell version 5's integraion with Excel’ is closed to new replies.