Leggi e rivedi la documentazione di Automation Anywhere

Automation Anywhre Automation 360

Chiudi contenuti

Contenuti

Apri contenuti

Excel base pacchetto

  • Aggiornato: 7/08/2021
    • Automation 360 v.x
    • Crea
    • Spazio di lavoro RPA

Excel base pacchetto

The Excel base pacchetto contains azioni that enable you to automate many of the repetitive tasks in XLSX workbooks. You use these azioni when Microsoft Excel is not available on the device that you want to use to automate Microsoft Excel-related tasks.

Choosing the Excel pacchetto in Automation 360

Automation 360 includes pacchetti to support three types of Microsoft Excel usage. For optimal results, use the pacchetto that corresponds to the type of Excel that is available on the device you are running bot on.

  • No Excel installed: If you do not have Microsoft Excel installed on the device on which you are running bot to automate Excel-related processes, use the Excel base pacchetto.
  • Desktop Excel installed: If you have a desktop version of Microsoft Excel installed on your computer, use the Excel avanzato pacchetto in your bot.
  • Online Excel per Office 365 only: If you are using Microsoft Excel 365 on a web browser, use the Excel per Office 365 pacchetto for automating tasks related to Excel.

To learn more, search for the Automating Excel Workbooks course in Automation Anywhere University: RPA Certification Courses (A-People login required).

Before you start

Perform the following azioni within the Excel base pacchetto as part of using the set of available azioni:
  1. Open the Microsoft Excel spreadsheet that you want to read data from using the Open azione.
    Note: The Excel base pacchetto supports files that are a maximum size of 30 MB.

    You must associate the details of the file you want to use with a session name, and use the session name in the other azioni in the Excel base pacchetto, so that you do not have to provide the details of the file in those azioni again. See Apri.

  2. Use the different azioni available in the Excel base pacchetto to automate the Microsoft Excel-related tasks.
  3. After you have automated all the Microsoft Excel-related tasks, close the spreadsheet using the Close azione.

Azioni in the Excel base pacchetto

The Excel base pacchetto includes the following azioni:

Azione Description
Switch to sheet Switches to another sheet in a Microsoft Excel file.
  • Select the Sheet by Index (numerical value) or Sheet by Name option to specify how to activate the sheet.
  • Enter the name of the session used to open the workbook with the Open azione.
Close Closes the current workbook and provides an option to Save changes when closing the file.Enter the name of the session used to open the workbook with the Open azione.
Note: This azione terminates the process for the session.
Delete cell Deletes the Active cell or a Specific cell from the current worksheet or a CSV file.
  • Select the Shift cells left or Shift cells up option to specify whether to shift the cell one position to the left or up after the cell is deleted.
  • Select the Entire row or Entire column option to specify whether to delete the entire row or column of the cell.
  • Enter the name of the session used to open the workbook with the Open azione.
Find See Trova e sostituisci.
Get cell address Retrieves the location of the active cell and stores it to a string variable.
  • Enter the name of the session used to open the workbook with the Open azione.
  • In the Save the active cell address in local variable field, create or insert an existing string variable.
Get column name Retrieves the letter value of the column of the active or specific cell and stores it to a string variable.
  • Select the Active cell or Specific cell option to specify whether to retrieve the column name from the active cell or a specific cell.
  • Enter the name of the session used to open the workbook with the Open azione.
  • In the Save the column name into local variable field, create or insert an existing string variable.
Get multiple cells Retrieves the values from cells in a Microsoft Excel spreadsheet and stores them in a table variable.
This azione retrieves cell values as string data types. It supports Excel cell formats, including Number, Percentage, Currency, Scientific, and Date. For example, a value from a cell of Currency formatting retains the currency symbol when passed to a table or record variable.
Note: You must convert the values to perform non-string operations.
  • Select the Multiple cells or All cells option to specify whether to retrieve the values from a range of cells or all the cells.
  • Enter the name of the session used to open the workbook with the Open azione.
Get row number Retrieves the row number of the active or specific cell and stores it to a string variable.
  • Select the Active cell or Specific cell option to specify whether to retrieve the row number from the active cell or a specific cell.
  • Enter the name of the session used to open the workbook with the Open azione.
  • In the Save the row number into local variable field, create or insert an existing string variable.
Get single cell Retrieves the values from a single cell in a Microsoft Excel spreadsheet or a CSV file and stores them in a string variable.
This azione retrieves cell values as string data types. It supports Excel cell formats, including Number, Percentage, Currency, Scientific, and Date. For example, a value from a cell of Currency formatting retains the currency symbol when passed to a table or record variable.
Note: You must convert the values to perform non-string operations.
  • Select the Active cell or Specific cell option to specify whether to retrieve the values from the active cell or a specific cell.
  • Enter the name of the session used to open the workbook with the Open azione.
  • In the Store cell contents to field, create or insert an existing string variable.
You can use the output value to Esempio di utilizzo di un'istruzione condizionale.
Go to cell Selects a specific cell in a Microsoft Excel spreadsheet or a CSV file.
  • Select the Active cell or Specific cell option to specify which cell to select.
  • Enter the name of the session used to open the workbook with the Open azione.
Open Reads data from a Microsoft Excel spreadsheet. See Apri.
Note: This azione does not open a Microsoft Excel spreadsheet. It only enables a task to read data from the spreadsheet.
Replace See Utilizzo del pulsante Sostituisci azione.
Save workbook Saves a Microsoft Excel spreadsheet to a specified location. Enter the name of the session used to open the workbook with the Open azione.
Note: When you open an excel file from the Sala di controllo and make changes in the file, the updated file does not save in the Sala di controllo This azione is supported only for Excel files opened from the desktop.
Set cell Sets the value you have specified in a cell in a Microsoft Excel spreadsheet. Select the Active cell or Specific cell option to specify whether to set the value in the active cell or a specific cell.
Set session variable Assigns the session name to a variable.

Use this azione in a parent bot, and then insert the variable containing the session name in Excel-related azioni in the child bot to associate the azioni with the file opened in that session. When you run the bot, it passes the session variable to the child bot, which enables the child bot to process the data in the file opened in the parent bot.

Note: The parent and child bot must use azioni from the same Excel pacchetto version to pass the session variable.

Esempio di condivisione di una sessione Excel tra bot

Switch to sheet Activates a specific worksheet.
  • Select to activate the worksheet by the Index value or worksheet Name.

    The index is the numeric value assigned to the worksheet.

  • Enter the name of the session used to open the workbook with the Open azione.
Invia feedback