Counting of Excel Rows dynamically

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)

@ROBERT_RUSSELL_MONSA

you can do read range with range “”, and this will be stored in datatable then do datatable.Rows.Count

How will I put the total number of rows here?

@ROBERT_RUSSELL_MONSA

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)


I’m sorry but it does not print. What can I do for this?

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 :
dd

1 Like

@ROBERT_RUSSELL_MONSA

Please find the xaml attached here, for writing write cell activity you can refer the xaml where I have commented it.

Ouput screenshot
image

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.