Lire et examiner la documentation Automation Anywhere

Automation 360

Fermer les contenus

Contenus

Ouvrir les contenus

Using the Open action for Excel basic

  • Mis à jour le : 2021/12/22
    • Automation 360 v.x
    • Créer
    • Espace de travail 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.

Procédure

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:
    Remarque : Le Excel basic packageprend en charge les fichiers d’une taille maximale de 30 Mo.
    • 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.
Envoyer le commentaire