Scott_Owens

Excel custom operators and example processes

Discussion created by Scott_Owens Employee on Oct 14, 2013
Latest reply on Feb 9, 2015 by Scott_Owens
This download provides a set of custom operators for Microsoft Excel. These custom operators leverage PowerShell to automate Excel via COM. Included in the download are four sample processes showing how to use these custom operators to manipulate Excel.

There are currently 4 Operators:

Get Cell
Retrieves cell or cell range from Excel workbook and returns data as PAM value map.

Update Cell
Updates a cell or cell range with specified value or string.

Copy Paste Cell
Copy past cell range between sheets.

Find Replace Value
Find and optionally replace values for a given cell range.

Prerequisites:
PAM 4.1 SP1
PowerShell
Microsoft Excel 2003 or later

Operators and Examples for Excel.zip

Thank you.

Outcomes