Excel node is used to access an Excel spreadsheet and perform different actions that enable you to automate many of the repetitive tasks when working with Microsoft Excel spreadsheets.
You can automate tasks related to the workbook, worksheet, rows, columns, and cell operations.
Using an Excel node, you can get the cell value from an Excel spreadsheet, manipulate it, assign it to a variable and map it to the succeeding node for further automation steps.
To use an excel node, ensure that Microsoft Excel (Licensed) application is installed in your machine.
Double-click the Excel node.
Enter the Configuration Name and Cluster in Configurations tab.
In Actions tab, you can define actions to be performed in Excel node.
Double-click the Excel node and navigate to Actions tab. Select one of the following options from the first drop-down:
You can copy, cut, comment, uncomment, debug, select all, or deselect all actions using the Toolbar options.
You can automate repetitive tasks in Microsoft Excel using Excel Macros. A Macro is an action or a set of actions that you can run as many times as required. When a Macro is created, the mouse clicks and keystrokes are recorded.
You can also execute Macros using the Run Macro pre-defined function.
Excel must be configured to accept VBA macros execution.
Navigate to File > Option > Trust Center > Macro Settings page and enable the following highlighted options.
Click the icon on Design Studio Page.
Select the Excel Macros option to display Excel Macros tab.
Click the icon to add a new Excel Macro.
Specify the following details in the Add New Excel Macro window.
Click the Save button.
All Excel Macros created are displayed in Excel Macros tab.
The Function Name must be the same as the code following the Sub line.
All Macros created in that node gets displayed in the drop-down. Select the Macro based on your requirement.
All Input/Local variables created for the node are displayed under Variables tab.
All Default and Custom DataTables created in the Task are displayed under Table Definitions tab.
After executing task, Result of Execution window is displayed with Input, Excel Output, Run Info, Raw Output, and Step Data tabs.