In excel there are 2 ways of specifying a range
A2:C10 This traditional style is supported. Secifies the cells from Column A row 2 till Column C row 10
R2C1:R10C3 This is a R1C1 reference style which is supported by excel.[Screenshot attached] But, when this style range is specified in the read range activity, an error is thrown which says -` `**`Invalid Address format`**``
If an address format is supported by excel, I expect UiPath should also have supported it.
For huge excel inputs it is not always that we can have datatables created for entire ranges. Also, when there is a need for reading custom ranges within loops, conversion from iteration variables to Column names comes into picture(Eg. variable value 3 should get converted to Column C & value 28 to AB)(this further varies when someone’s indexing starts from 0 which means 3 = D and 28 = AC)
This R1C1 Reference style of specifying range will definitely be a huge help. wouldn’t it?