UiPath-ADAv1 Excel and Email Automation Practice Question
Exhibit
EXHIBIT: Activity: Read Range WorkbookPath: "Data.xlsx" Range: "A1:B10" AddHeaders: True DataTable variable output: dt_Result LOG: System.ArgumentException: The range does not exist.
Refer to the exhibit. Why is the Read Range activity throwing an exception even though 'Data.xlsx' exists and contains data?
⚠ Common exam trap
Candidates assume that if a file exists, the Read Range activity will automatically default to the first sheet, ignoring missing or misspelled sheet names.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The SheetName property is incorrect or missing.
The error 'The range does not exist' often occurs when the specified SheetName is missing or invalid in the workbook. While the activity refers to the file, it requires a valid sheet reference. If the default sheet name does not match (e.g., the sheet is named 'Sheet1' but the activity defaults to blank), the robot cannot locate the range, leading to an argument exception during execution.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The file is password protected and cannot be opened.
Why it's wrong here
If a file were password protected, the error message would typically be 'Access Denied' or 'Could not open file'. The 'Range does not exist' error specifically points to a failure in locating the specified worksheet or grid area within an successfully opened Excel file.
- ✓
The SheetName property is incorrect or missing.
Why this is correct
Read Range requires a valid worksheet name to locate the specified range. If the SheetName property is left blank and the workbook does not have a sheet matching the default expectation, or if the name provided is misspelled, the activity fails to bind the range, causing this specific exception.
- ✗
The DataTable variable 'dt_Result' is not initialized.
Why it's wrong here
In UiPath, the Read Range activity automatically initializes the output DataTable variable if it is null. Therefore, an uninitialized variable would not cause the 'Range does not exist' error; the activity would simply create a new DataTable instance and assign the read data to it.
- ✗
The file is currently being edited by another user.
Why it's wrong here
If the file were locked by another user, the error would typically be an 'IOException: The process cannot access the file because it is being used by another process'. This is distinct from the argument exception regarding the range location, which relates to the internal Excel structure.
About these practice questions
One of 285 original UiPath-ADAv1 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official UiPath exam blueprint
This UiPath-ADAv1 practice question is part of Courseiva's free UiPath certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the UiPath-ADAv1 exam.