IT Process Automation

  • Private Community

  • 1.  Excel custom operators and example processes

    Broadcom Employee
    Posted Oct 14, 2013 11:01 AM
    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.


  • 2.  Re: Excel custom operators and example processes

    Broadcom Employee
    Posted Feb 09, 2015 11:44 AM

    The link to the Operator and Examples for Excel.zip file seems to have been moved.  You can download the file from the following location:

     

    Operators and Examples for Excel.zip

     

    Thank you.