Leggi e rivedi la documentazione di Automation Anywhere

Automation Anywhere Automation 360

Chiudi contenuti

Contenuti

Apri contenuti

Cell operations

  • Aggiornato: 2020/02/12

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