UiPath-ADAv1: UiPath Automation Developer Associate

By UiPath · Question Mode

QuestionQ166

VerifiedExcel Automation

A developer uses the activity shown below to extract data from Sheet1 in the Test.xlsx file, which contains 10,000 rows of data:

Question Image

Additionally, the developer configured these properties for the Workbook Read Range activity:

Question Image

Based on the exhibits, what is the result of the expression OutputDataTable.Rows.Count, and which values will be included in OutputDataTable?

Explanation

The range A1:B2 limits the extraction to two rows and two columns. With AddHeaders selected, the first row of that range becomes the DataTable column headers; it is not included as a DataRow. The DataTable therefore has one row, containing the values from A2 and B2. UiPath documents that Read Range stores the specified range in a DataTable and that selecting AddHeaders extracts the range's column headers.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!