UiPath-ADAv1 Excel and Email Automation Practice Question
You are automating an Excel process where you need to write a DataTable to an Excel file. You want to ensure that the existing data in the sheet is not overwritten but appended below the last row. Which activity and configuration should you use?
⚠ Common exam trap
The trap here is assuming that 'Write Range' with an empty range appends data, when in fact it overwrites from A1.
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
✓
Use the 'Append Range' activity within a 'Use Excel File' activity.
The 'Append Range' activity is designed to add data to the end of an existing sheet or table. It automatically finds the last row and appends the DataTable, ensuring existing data is preserved. This is the most efficient and reliable method for appending data in Excel automation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the 'Write Range' activity and set the 'Range' property to the last row number plus one.
Why it's wrong here
While you can manually calculate the next empty row and set the 'Range' property accordingly, this approach is error-prone and not dynamic. The 'Append Range' activity is purpose-built for this scenario and handles the detection automatically. Using 'Write Range' with a manually calculated range requires additional steps and can fail if the sheet structure changes.
- ✗
Use the 'Write Cell' activity in a loop to write each row individually.
Why it's wrong here
Using 'Write Cell' in a loop is highly inefficient for large DataTables and does not ensure appending without overwriting unless you carefully manage the row index. It also does not preserve existing data if not configured correctly. The 'Append Range' activity is optimized for this task and should be used instead.
- ✓
Use the 'Append Range' activity within a 'Use Excel File' activity.
Why this is correct
The 'Append Range' activity is specifically designed to add data to the end of an existing table or sheet. It automatically detects the last row and appends the DataTable below it, preserving existing data. This is the correct activity for appending data without overwriting.
- ✗
Use the 'Write Range' activity within a 'Use Excel File' activity and set the 'Range' property to an empty string.
Why it's wrong here
Setting the 'Range' property to an empty string in the 'Write Range' activity writes the DataTable starting at cell A1, which overwrites existing data. To append data, you need to specify a range that starts after the last row of existing data. An empty range does not achieve appending.
About these practice questions
Courseiva writes every UiPath-ADAv1 question from scratch — 285 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-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.