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 184.108.40.206 Microsoft.PowerShell.Management
Cmdlet Set-Clipboard 220.127.116.11 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*'
ReTweet this Tip!
Powered by IDERA