Excel count row

Help Activities
, ,
1

excel
excel1186×399 66.7 KB

Hi, i have this list of data in excel, column B,C and D will be updated. For column A, i would like to automate the row count using UiPath, how can i do it?

2

@Joanna2
Try this

  • Use Excel application scope with Read range activity of “A:A” range and store as a aDT
  • you can get the row count by using DT.Rows.Count
3

Hi,

Are there already data in A7 and A8 cell? If so, can you try AutoFill activity as the following?

image
image657×709 17.4 KB

Regards,

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.