Page 1 of 1

A developer needs to extract data from "Sheet1" of the "Test.xls" file that contains 10,000 rows of data using the code

Posted: Wed Mar 15, 2023 5:18 am
by answerhappygod
A developer needs to extract data from "Sheet1" of the "Test.xls" file that contains 10,000 rows of data using the code shown in the following exhibit:

In addition, the developer configured the following properties of the Read Range activity:

Based on the exhibits, what is the output of the expression, OutputDataTable.Rows.Count and what values will be contained in the OutputDataTable?
A Developer Nee 1
A Developer Nee 1 (17.09 KiB) Viewed 48 times
A Developer Nee 2
A Developer Nee 2 (5.68 KiB) Viewed 48 times
A. OutputDataTable.Rows.Count = 1 -
Contains the values of cells "A2" and "B2"
B. OutputDataTable.Rows.Count = 2 -
Contains the values of cells "A1" and "B1"
C. OutputDataTable.Rows.Count = 2 -
Contains the values of cells "A2" and "B2"
D. OutputDataTable.Rows.Count = 10,000
Contains the values of cells "A2" and "B2"