Excel PowerShell Console ![]()
|
An Excel AddIn to enable using PowerShell for Excel automation. Excel PowerShell Console 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"
Requirements:
* Office Excel
* Net Framework
The license of this software is Free, you can free download and free use this microsoft office add-ins software.