Which datatype needed for an Excel file?

Which datatype needed for an Excel file?

Question: Which data type is used for extracting data from a Microsoft Excel file using a Read Range activity?

  •   DataTable
  •   Array
  •   Object
  •   String


Option A is correct.

The correct answer is A. Data Tables are explicitly used when working with Excel as they are the closest argument type to mimicking an excel spreadsheet. An array would not work as they are typically one dimensional and you need to know the size before hand. String manipulations would be very cumbersome to use. While Objects are great in general, the Data Table was created for this job.

Please subscribe to Cameron's YouTube channel