Excel System Variables
You can use Excel System Variables to manage Excel automation processes. These variables are specific to the scope of the Excel command.
Excel relevant system variables
- Excel Cell - This will indicate the column name and position of the cell from the header, when 'Contains Header' is enabled for a session in Open Spreadsheet of the Excel Command. It is applicable to Excel operations like Get Cells, Set Cells, Go to Cell, Delete Cells and Find/Replace.
- Excel Cell Column - This will return the column of the Excel on which the operation has been performed.
- Excel Cell Row - This will return the cell of the Excel on which the operation has been performed.
To know more about the Excel operation, refer Excel command - Contains Header