Uipath Certified RPA Associate Uirpa · Free Practice Question Medium
Question 1
Which of the following activities can be used to add data to an existing .xlsx document without overwriting existing data? (Select two)
-
A
Workbook Append Range
-
B
Excel Append Range
-
C
Excel Write Cell
-
D
Workbook Write Range
Reveal correct answers
Correct answers: A, B
Explanation
Excel Append Range and Workbook Append Range can be used to add data to an existing .xlsx document without overwriting existing data.
File Access Level
All workbook activities will be executed in the background.
• Doesn't require Microsoft Excel to be installed, can be faster and more reliable for some operations just by not opening the file;
• Works only for .xlsx files.
https://docs.uipath.com/activities/docs/append-range
Excel App Integration
UiPath will open Excel just like a human would.
• Works with .xls and .xlsm, and it has some specific activities for working with .csv. All activities can be set to either be visible to the user or run in the background;
• Microsoft Excel must be installed, even when the 'Visible' box is unchecked. If the file isn't open, it will be opened, saved and closed for each activity.
https://docs.uipath.com/activities/docs/append-csv-file
Both access levels share some activities, with Excel App Integration having several more. Please note that in UiPath there are two activities for each method presented below - one under 'App Integration → Excel', the other under 'System → File → Workbook’.
Append Range
Adds the information from a DataTable to the end of a specified Excel spreadsheet. If the sheet does not exist, it creates it.
Get Table Range
Locates and extracts the range of an Excel table from a specified spreadsheet using the table name as input.
Read Cell
Reads the content of a given cell and stores as String.
Read Cell Formula
Reads the formula from a given cell and stores it as String.
Read Column
Reads a column starting with a cell inputted by the user and stores it as an IEnumerable <object> variable.
Read Range
Reads a specified range and stores it in a DataTable. If 'Use filter' is checked in the Read Range activity under 'Excel Application Scope', it will read only the filtered data. This option does not exist for the Read Range activity under 'Workbook'.
Read Row
Reads a row starting with a cell inputted by the user and stores it as an IEnumerable <object> variable.
Write Cell
Writes a value into a specified cell. If the cell contains data, the activity will overwrite it. If the sheet specified doesn't exist, it will be created.
Write Range
Writes the data from a DataTable variable in a spreadsheet starting with the cell indicated in the StartingCell field.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
