Leggi e rivedi la documentazione di Automation Anywhere

Automation Anywhre Automation 360

Chiudi contenuti

Contenuti

Apri contenuti

Cell operations

  • Aggiornato: 2/12/2020
    • Automation 360 v.x
    • Crea
    • Spazio di lavoro RPA

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:

Azione 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 azione.
  • 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 azione.
  • 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 azione.
  • 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 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 azione.
  • 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 azione.
  • 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 azione.
  • 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 azione.
  • 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 azione.
  • Select the Active cell or Specified cell option to specify the cell from which to copy the value.
  • 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 azione.
  • Select the Active cell or Specified cell option to specify the cell from which to read the format.
  • Select a String variable to store the cell format from the Assign the output to variable list.
Read cell formula
Set cell
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 azione.
  • Select the Active cell, Specified cell, or Cell range option to specify the cell in which to set the color.
  • 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 azione.
  • Select the Active cell, Specified cell, or Cell range option to specify the cell in which to set the color.
  • Enter the value to set in the Cell formula field without an "=".
Invia feedback