I would like to ask if there is way to autofill column in excel without a specified range. As of now, I have to key in a certain range (e.g. “A2:A33”), but my excel files always vary in its range, so this method is not very useful. Is there a formula I can key in that will enable the system to autofill from A2 to the last column - regardless if it is “A33” or “A140” or “A1200”, for example. Thank you!
Please use READ RANGE activity and DatatableVariable.Rows.Count.ToString to know the count of your rows in Excel sheet
Thank you so much, this solution worked.
@Isyraf_Salahudin happy to hear , please mark my answer as solution, so it will help others when they search the same query…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.