Autofill Excel Function

Hi everyone,

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!

Hi @Isyraf_Salahudin

Please try this,

  1. You can read the excel data and store in a data table (dtTable)
    2 And in autofill give range as “A2:A” + dtTable.rows.count.tostring


1 Like

Hi @Isyraf_Salahudin,

Please use READ RANGE activity and DatatableVariable.Rows.Count.ToString to know the count of your rows in Excel sheet

1 Like

Hi Sir,

Thank you so much, this solution worked.


@Isyraf_Salahudin happy to hear :grinning:, 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.