Hi, Which of the following activity is best suited for reading data from excel file? Read Range_1 or Read Range_2
Both do the same thing. One requires Excel Application Scope (or modern Use Excel File), the other (the workbook activities) don’t, and also don’t require Excel to be installed.
You can use any one of the read range activity. Both the activity are doing the same thing based on the need you can try.
I recommend to use ReadRangeX (the former) basically, because Modern activities will be mainstream in the near future. However, sometimes it has performance issue especially in older version. If you face this issue, please use ExcelReadRange (the latter).