UiPath-ADPv1 Resource Management Practice Question
A developer needs to ensure that a UiPath automation can run on a machine that does not have Microsoft Excel installed. The automation must read data from an Excel file and write it to a DataTable. Which activity should be used to achieve this?
⚠ Common exam trap
The trap here is assuming that Excel Application Scope is always needed for Excel files, overlooking the Workbook activities that work without Excel installed.
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
✓
Workbook Read Range
Workbook Read Range is the correct activity because it reads Excel files using the Open XML SDK, which does not require Microsoft Excel to be installed. Excel Application Scope relies on Interop and requires Excel, while Read CSV and Read Text File handle different file formats and do not return a DataTable from an Excel file.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Read CSV
Why it's wrong here
Read CSV reads data from a CSV file, not an Excel file. While it can produce a DataTable, it does not handle Excel formats like .xlsx or .xls. The scenario specifically mentions an Excel file, so this activity is not appropriate.
- ✗
Excel Application Scope with Read Range
Why it's wrong here
Excel Application Scope uses the Excel Interop library, which requires Microsoft Excel to be installed on the machine. Without Excel, this activity will fail. Therefore, it cannot be used in the scenario where Excel is not installed.
- ✓
Workbook Read Range
Why this is correct
Workbook Read Range is part of the UiPath.Excel.Activities package and uses the Open XML SDK to read Excel files without requiring Microsoft Excel to be installed. It can read data into a DataTable, making it suitable for environments where Excel is not available.
- ✗
Read Text File
Why it's wrong here
Read Text File reads the entire content of a text file into a string. It does not parse Excel files or return a DataTable. It would require additional parsing to extract data, which is inefficient and not designed for Excel files.
About these practice questions
Courseiva writes every UiPath-ADPv1 question from scratch — 276 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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-ADPv1 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-ADPv1 exam.