How to count rows in excel dynamically where in the number rows in a column is not pre-determined then the total number of rows will be placed after the last row?
Copying of Selected Column through Column Letter.xaml (8.7 KB) excel.xlsx (9.9 KB)
you can do read range with range “”, and this will be stored in datatable then do datatable.Rows.Count
in your example there is write cell activity with cell field M11. As rows are dynamic you can do write cell with cell field - “M”+(datatable.Rows.Count+1)
What if the number of rows that will be copied and pasted are not determined that it is 10 rows? How I will put the number of rows after the last rows?
How can I do this, Sir @Vishal_K ?
@ROBERT_RUSSELL_MONSA I think it should be in this way :
1 Like
Please find the xaml attached here, for writing write cell activity you can refer the xaml where I have commented it.
Ouput screenshot
Robert.zip (9.7 KB)
1 Like
Thank you Sir @supermanPunch
1 Like
Thank you Sir @Vishal_K
@ROBERT_RUSSELL_MONSA
Please mark the answer as solution if it helps!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.