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

  1. 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.
  2. Excel Cell Column - This will return the column of the Excel on which the operation has been performed.
  3. 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