Leggi e rivedi la documentazione di Automation Anywhere

Automation 360

Chiudi contenuti

Contenuti

Apri contenuti

Using the Open action for Excel basic

  • Aggiornato: 2021/12/22
    • Automation 360 v.x
    • Crea
    • Spazio di lavoro RPA

Using the Open action for Excel basic

Use the Open action to open a Microsoft Excel spreadsheet with .xlsx extension. This action enables you to specify whether to open the spreadsheet in read-only mode or read-write mode, a password to open the spreadsheet, and so on.

Procedura

To open a Microsoft Excel spreadsheet, do the following:

  1. Double-click or drag the Open action from the Excel basic package in the Actions palette.
  2. Select from where you want to open the Microsoft Excel spreadsheet:
    Nota: The Excel basic package supports files that are a maximum size of 30 MB.
    • Control Room file: Enables you to open a file from the Control Room.
    • Desktop file: Enables you to open a file from the device. This field also accepts the file path input as a string variable or global value.
    • Variable: Enables you to open a file by specifying a file variable.
  3. Select the Sheet contains a header check box if the Microsoft Excel spreadsheet contains a header row.
  4. Select the Specific sheet name option and specify the name of the sheet to activate when the Microsoft Excel spreadsheet opens.
  5. Select Read-only mode or Read-write mode to open the Microsoft Excel spreadsheet in read-only or edit mode respectively.
  6. Select the Password is required check box if a password is required to open or edit the Microsoft Excel spreadsheet.
  7. Enter the name of the session in the Session name field.
Invia feedback