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.

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.