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*'
