UiPath and Excel

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

  •   DataTable
  •   Array
  •   Object
  •   String

Answer

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.

Discuss with Us on Twitter
UiPath Tutorials on YouTube
Check out this UiPath Youtube tutorial from @cameronmcnz.
#UiPath #UiPathCertified #RPACertified #RPA #RPACertification #UiPathTutorial