Get number of used row in Excel

Help Forum
1

Hi devs, please assist on actions or how to get the number of rows used in excel

2

Hi @RPA-botDev

First you have to read the input excel file using read range activity and create a output datatable for that activity like DT

Create a integer variable in variables panel ex Count

Drag and drop the assign activity and keep it below the read range activity

Finally put the below syntax in the assign activity to get row count

Count = DT.Rows.Count

Hope it solves your issue

Thanks
Robin

3

Hi Robinnavinraj_S, please is there a way we can get it using xlWorksheet.UsedRange and assign datatable to it.Regards

4

Select the cells and at the bottom of the screen you will see “Count” which is the number of cells that have data in them.