Question 35

Explanation

You will need to add Use Excel File to be able to use Modern Excel activities.

The Use Excel File

Activities especially created for Excel automation are enabled by using an Use Excel File activity. Just as the "Excel Application Scope" activity from the Classic Design Experience, "Use Excel File" is a container in which all other Excel activities need to be placed.

Activity Properties

Common: DisplayName - The name displayed for the activity in the Designer panel.

File:

• Edit password - The password required for editing the Excel workbook, if the file is password-protected.

• Password - The password required for opening the Excel workbook, if the file is password-protected.

• Workbook path - The path to the Excel file. If the file doesn't exist and you select the CreateNewFile option, StudioX creates the file.

Misc:

• Private - If selected, the data used in the activity is not logged by StudioX.

Options:

• Create if not exists - See the description in the body of the activity.

• Keep Excel file open - If the file isn't open at the time the project runs, it keeps the workbook open after the project has finished running instead of closing it. This can be used to review the file afterward.

• Read Formatting - See the description in the body of the activity.

• Read-only - If selected, the specified workbook is opened in Read-Only mode. Selecting this check box enables you to perform data extraction operations in an Excel file that is locked for editing or has an edit password. This option isn't selected by default.

• Save changes - See the description in the body of the activity.

Important note: If the same workflow deals with information from two or more Excel files, a Use Excel Activity has to be used for each file.

https://docs.uipath.com/studiox/docs/excel-automation