Creating Reports in Excel Using PowerShell

Create an Inventory of the Local Computer

 

Getting Computer Services

 

The Output should look like this

 

PS C:\>

VERBOSE: Select-SLWorkSheet :     Worksheet ‘Services’ is now selected

VERBOSE: Set-SLTableStyle : Setting TableStyle ‘Medium15′ on CellRange – StartRow/StartColumn ‘5’:’2′ & EndRow/EndColumn ‘184’:’16’

VERBOSE: Save-SLDocument : Document has been Saved to ‘c:\temp\excel\Localhost-Inventory.xlsx’

 

Check the target folder to confirm a file with our filename ‘Localhost-Inventory.xlsx’ was created.

image

 

Open the file to check the contents:

 

image

 

Getting Disk Information

Leave a Comment Yourself

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">