I’ve liked the simplicity of PowerShell when using the Out-GridView against a data set when you want a quick sort-able list.

If you use Out-GridView most likely you’re cutting and pasting into an Excel sheet

Out-GridView dosen’t allow you to copy the header row. But, a simple process will help

For Example

From example #4 on this page. https://technet.microsoft.com/en-us/library/hh849920.aspx

($A = Get-ChildItem -Path $pshome -Recurse) | Out-GridView

This displays the header bar but you’re unable to copy this header directly that I’ve not found.

CTRL+A and no grid headers selected.

Now create a simple object and function to run for storing header values:

$global:ReportHeaders = @()

function Report-Headers() {  # There are a few methods for createing objects. Keeping this simple  # to show the possibilities # Sets up dummy object with headers for use in out-gridview  $local:TestCollection = @()  $TestProperties = new-Object Object  add-Member -inputobject $TestProperties -membertype NoteProperty  -Name "Mode" -Value ""  add-Member -inputobject $TestProperties -membertype NoteProperty  -Name "LastWriteTime" -Value ""  add-Member -inputobject $TestProperties -membertype NoteProperty  -Name "Length" -Value ""  add-Member -InputObject $TestProperties -MemberType NoteProperty  -Name "Name" -Value "" $TestProperties.Mode = "Mode"  $TestProperties.LastWriteTime = "Last Write Time"  $TestProperties.Length = "Length"  $TestProperties.Name = "Name"  $local:TestCollection += $TestProperties  $global:ReportHeaders = $local:TestCollection  } Report-Headers  ($A = Get-ChildItem -Path $pshome -Recurse) | Out-GridView  $global:ReportHeaders +=  $a  $global:ReportHeaders | Out-GridView 

Now there are simple headers to copy into excel or other tools.

Out-GridView with Headers

Excel Sample

Simple PowerShell

Well, something very simple. If you’ve found a different way to do this please let me know. In a pinch PowerShell can create some simple report headers that are good for automating simple excel reports.

Joseph Kravis

Thank you! For visiting this post! Your time and interest are truly appreciated. If you found the content engaging or thought-provoking, please feel free to share your thoughts or insights in the comments.

Thoughts & Ideas, Joseph Kravis 🙂

Categories: PowerShell Posts, Technology

Tags: #azure, #office365, #sharepoint, #sqlserver, Grid, Out, Out-GridView, View