What will be the result of the processing if the indicated workbook does not exist?

A developer created a UiPath Process to find out, how many worksheets an Excel file stores.

What will be the result of the processing if the indicated workbook does not exist?

Please find the properties of the Excel Application Scope activity below:

Please find the properties of the Get Workbook Sheets activity below:

A . An error will be thrown.
B. A Message Box will display "0".
C. A Message Box will display "No sheets found".
D. A Message Box will display "1".

View Answer

Answer: D

Explanation:

When Create if not exists property is checked, if the workbook cannot be found at the specified path, a new Excel workbook is created with the name specified in the Workbook path property field. When not checked, if the workbook cannot be found at the specified path, an exception is thrown, informing the user.

In this case, Create if not exists property is checked, so a new workbook with a default 1 worksheet will be created. As a result, a Message Box will display "1". UiPath Documentation

Exam Topic: Identify and describe how activities are used to automate actions in Excel, e-mail, and .pdfs.