Project DescriptionAn Excel AddIn 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"
If you know your way around, and you think using PowerShell for Excel automation is not a bad idea, please join.
Documentation pages
Global Variables Support in ConsoleRead-Host FunctionalityPrompt for ParametersRead-ExcelRange (Cmdlet)Write-Excel(Cmdlet)