Get number of used row in Excel

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

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


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

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.