What’s the answer guys for the two questions?
Explanations will be highly appreciated.
Thanks in advance.
hi,@Latifa
- Option B
- Option A
1 Like
H! @Latifa
Answer: B
I will go with ‘B’ because answers are mentioning row(s) containing values. A1 and B1 are headers even if they got printed when you using output datatable and printing the result in string format. While A2 and B2 are row values and there will be only only 1 row.
Hi @Latifa
Answer is B. OutputDataTable object will have 2 columns and 1 row containing values of cells “A2” and “B2”.
The “Read Range” activity with the specified range “A1:B2” will read the data from cells A1 to B2, inclusive. Since the “AddHeaders” option is enabled, it assumes that the first row (A1 and B1) contains headers. Therefore, the actual data extraction starts from the second row, which is A2 and B2.
The extracted data will be stored in the OutputDataTable, resulting in a DataTable with 2 columns and 1 row containing the values of cells “A2” and “B2”.
Hello @Latifa , The answer is B.
Explanation:
When you enable the “Add headers” option in the “Read Range” properties, the system identifies the first row as the header. Consequently, the data begins from the second row in the Excel file. In other words, A1 and B1 serve as headers, while A2 and B2 contain the actual values.
The questions are two @Praveen_Mudhiraj @pravallikapaluri @Gokul_Jayakumar. Is B for both?
1 Like
@Latifa , For the Second question Answer, is “A”.
As for 1 st Question, it reads only 2 rows where the 1st row was a header. Then it shows the row count as 1 and which has data od A2 & B2.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.