Finally in PowerShell 5, there is support for sending results to the clipboard, and receiving results from the clipboard:

 
PS> Get-Command -Noun Clipboard 

CommandType Name          Version Source                         
----------- ----          ------- ------                         
Cmdlet      Get-Clipboard 3.1.0.0 Microsoft.PowerShell.Management
Cmdlet      Set-Clipboard 3.1.0.0 Microsoft.PowerShell.Management
 

For example, you can open Excel with some sheets of data, copy a column into the clipboard, and then in PowerShell tap into this data and filter it:

 
PS> $list = (Get-ClipBoard) -like '*err*'
 

Twitter This Tip! ReTweet this Tip!

Anonymous