| 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 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 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 "=".
|
