About the Excel Adapter

You can use the Excel adapter to map the value of a Automation Process Composer parameter to the value of a cell in a Microsoft Excel® worksheet. You can also map the value of a cell in an Excel worksheet to the value of a Automation Process Composer parameter.

See Also
Mapping Between Parameters and Cells
Running Excel Macros
Setting Execution Permissions

You can map both scalar and array parameters. You map a scalar parameter to/from a cell in a worksheet, and you can map an array parameter to/from a range of cells in a worksheet. In addition, you can run macros that are stored with a worksheet. Automation Process Composer allows you to determine the order in which cells are mapped and macros are run. Configuring the order allows Automation Process Composer to map parameters to cells that will be read by the macro, run the macro, and map parameters from cells that were written to by the macro.

You must configure the 3DOrchestrate Station to run the Excel adapter from Automation Process Composer. Excel add-ins provide optional commands and features and are supported by Automation Process Composer. You must use Excel to activate any add-ins run by the 3DOrchestrate Station.