UiPath and Excel
Question: Which data type is used for extracting data from a Microsoft Excel file using a Read Range activity?
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 specifically for this job.