Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Cell operations

  • Updated: 2/12/2020
    • Automation 360 v.x
    • Build
    • RPA Workspace

Cell operations

The Office 365 Excel package contains actions that you can use to automate tasks related to cell and range operations, such as append, delete, format, get properties, and insert.

The Office 365 Excel package includes the following actions:

Action Description
Delete cell Deletes the Active cell or a Specific cell from the current worksheet.
  • Enter the name of the session used to open the workbook with the Open action.
  • If you select Specific cell, enter the cell location. For example A1.
  • Select one of the following options:
    • Shift cells left: Deletes the specified cell and shifts the cell one position to left.
    • Shift cells up: Deletes the specified cell and shifts the cell one position up.
    • Entire row: Deletes the entire row that contains the cell that you have specified to delete.
    • Entire column: Deletes the entire column that contains the cell that you have specified to delete.
Delete range Deletes a specific range of cells.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the cell range. For example A1:B4. This deletes an area consisting of the first four rows by the first two columns.
  • Use the radio buttons to specify whether to shift the cells up or left.
    • Shift cells up: Deletes the specified cells and shifts the cells up by the number of rows deleted.
    • Shift cells left: Deletes the specified cells and shifts the cells left by the number of columns deleted.
Format cell See Using the Format cell action.
Get cell Retrieves the value of a cell.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell or Specific cell option and enter the cell location.
  • Assign the output to a String variable. To perform mathematical operations, convert the string to a number. See the String > Convert action.
Get cell/text color See Using the Get cell/text color action.
Get multiple cells Retrieves the value(s) of multiple cells within a worksheet and assigns the output to a variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Multiple cells or All cells option. If you select Multiple cells, enter the cell range, such as A1:D1. This retrieves the values of the first four cells in the top row.
  • Assign the output to a String variable. To convert the string to a number, see the String > Convert action.
Go to cell Moves the cursor to a specific cell in the worksheet.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select from the following options:
    • Specific cell: Moves to the specified cell address.
    • One cell to the left: Moves one cell left.
    • One cell to the right: Moves one cell right.
    • One cell above: Moves one cell up.
    • One cell below: Moves one cell down.
    • Beginning of row: Moves to the first cell in the same row.
    • End of row: Moves to the last cell that contains data in the same row.
    • Beginning of column: Moves to the first cell in the same column.
    • End of column: Moves to the last cell that contains data in the same column.
Insert cell Inserts a value to the Active cell or a Specific cell in the current worksheet without overwriting the existing value.
  • Enter the name of the session used to open the workbook with the Open action.
  • If you select Specific cell, enter the cell location. For example A1.
  • After inserting the cell, you can:
    • Shift cells down: Shifts the existing values down by the specified number of rows.
    • Shift cells right: Shifts the existing values right by the specified number of columns.
Insert range Inserts the range into the current worksheet without overwriting the existing value.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the cell range. For example A1:B4. This inserts a range of cells consisting of the first four rows by the first two columns.
  • After inserting the cell, you can:
    • Shift cells down: Shifts the existing values down by the specified number of rows.
    • Shift cells right: Shifts the existing values right by the specified number of columns.
Paste cell Copies a value from a cell and pastes to a specified cell. If there is a value in the destination cell, this action will overwrite the value.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell or Specified cell option to specify the cell from which to copy the value. If you have selected the Specified cell option, specify the address of the cell in the field.
  • Enter the destination cell address to paste the value. For example, B3.
Read cell format Gets the format of the Active cell or Specified cell and assigns the output to a string variable. This action returns a blank value if the specified cell does not contain a formula.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell or Specified cell option to specify the cell from which to read the format. If you have selected the Specified cell option, specify the address of the cell in the field.
  • Select a String variable to store the cell format from the Assign the output to variable list.
Read cell formula Gets the formula available in the Active cell or Specified cell and assigns the output to a string variable. This action returns a blank value if the specified cell does not contain a formula.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell or Specified cell option to specify the cell from which to read the formula. If you have selected the Specified cell option, specify the address of the cell in the field.
  • Select a string variable to store the name of the formula from the Assign the output to variable list. The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.
Set cell Sets a value in the Active cell or Specific cell in a Microsoft Excel spreadsheet or a CSV file. You can also use this action to set a formula.
  • Select the Active cell or Specified cell option to specify the cell in which to set the value. If you have selected the Specified cell option, specify the address of the cell in the field.
    Note: You can enter a cell range in the Specific cell field to set a particular value in all the cells of the range. For example, to set a value of 5 on all cells in the second row and from the first through third column, enter A2:C2.
  • Enter the value to set in the Cell value field.
  • Enter the name of the session used to open the workbook with the Open action.
Set cell color Sets a color to the background or text of the Active cell or Specific cell.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell, Specified cell, or Cell range option to specify the cell in which to set the color. If you have selected the Specified cell option, specify the address of the cell in the field.
  • Select which to apply the color to: the Cell or Text within cell.
  • Enter the value to set in the Cell value field. Use either the color name or the hex value. For a list of color names and corresponding hex values, see Frequently used cell colors.
Set cell formula Sets the formula of the specified cell.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell, Specified cell, or Cell range option to specify the cell in which to set the color. If you have selected the Specified cell option, specify the address of the cell in the field.
  • Enter the value to set in the Cell formula field without an "=".
Send Feedback