Uipath Certified RPA Associate Uirpa · Free Practice Question Easy
Question 13
Scenario: You need to write a data table to an .xlsx file. Currently the file does not exist.
If the Excel Write Range activity is used to write the data table, what will be the result?
-
A
Process will throw an execution error
-
B
File will be created and there will be no data
-
C
File will be created and the data will be located in the file
-
D
Process will continue the execution without creating the file
Reveal correct answer
Correct answer: C
Explanation
Write Range
UiPath.Excel.Activities.ExcelWriteRange
Writes the data from a DataTable variable in a spreadsheet starting with the cell indicated in the StartingCell field. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created with the value specified in the SheetName property. All cells within the specified range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activity.
Properties
Common
• DisplayName - The display name of the activity.
Destination
• SheetName - The name of the sheet in which the range that you want to write to is. By default, this is filled in with "Sheet1". Only String variables and strings are supported.
• StartingCell - The cell from which to start writing the data. Only string variables and strings are supported.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
