Excel PowerShell Console

This package provides an Excel add- In to enable using PowerShell for Excel automation. This is an Excel addin that adds a PowerShell engine to Excel. On installation a new ribbon called PowerShell is added with a button to show/hide a custom task pane containing a PowerShell console.

The console contains two textboxes, the upper is for entering PowerShell commands, and the lower displays output. There is also a toolbar with buttons to start and stop PowerShell command execution and to clear the output textbox.

When running the commands, the current instance of the Excel.Application object is available as a PowerShell variable named $Application. You can use:

$Application.Name

to display the Excel application name

or:

$Application.ActiveCell = "value"

to set the active cell value to "value"