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 Utilizzo dell'azione Formatta cella. |
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 Utilizzo dell'azione Ottieni colore cella/testo. |
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. Se hai selezionato l'opzione Cella specifica, devi specificare l'indirizzo della cella nel campo.
- 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. Se hai selezionato l'opzione Cella specifica, devi specificare l'indirizzo della cella nel campo.
- Select a String variable to store the cell format from the
Assign the output to variable
list.
|
Read cell formula |
Ottieni la formula disponibile in Cella attiva o Cella specifica e assegna l'output a una variabile stringa. Questa azione restituisce un valore vuoto se la cella specifica non contiene una formula.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Seleziona l'opzione Cella attiva o Cella specifica per specificare la cella dalla quale leggere la formula. Se hai selezionato l'opzione Cella specifica, devi specificare l'indirizzo della cella nel campo.
- Seleziona una variabile stringa per memorizzare il nome della formula dall'elenco Assegna l'output alla variabile. La Control Room mostra un nome descrittivo predefinito della variabile. Se si creano diverse variabili di output, ai nomi delle variabili successive vengono aggiunti -1, -2, -3 e così via per evitare duplicazioni.
|
Set cell |
Imposta un valore in Cella attiva o Cella specifica di un foglio di calcolo di Microsoft Excel o in un file CSV. Puoi utilizzare questa azione anche per impostare una formula.
- Seleziona l'opzione Cella attiva o Cella specifica per specificare la cella in cui impostare il valore. Se hai selezionato l'opzione Cella specifica, devi specificare l'indirizzo della cella nel campo.
Note: Puoi immettere un intervallo di celle nel campo Cella specifica per impostare un valore particolare in tutte le celle dell'intervallo. Ad esempio, per impostare un valore di 5 in tutte le celle nella seconda riga e dalla prima alla terza colonna, immetti A2:C2.
- Inserisci il valore da impostare nel campo Valore cella.
- 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. Se hai selezionato l'opzione Cella specifica, devi specificare l'indirizzo della cella nel campo.
- 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 Colori delle celle utilizzati di frequente.
|
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. Se hai selezionato l'opzione Cella specifica, devi specificare l'indirizzo della cella nel campo.
- Enter the value to set in the Cell
formula field without an "=".
|