HOW TO COUNT ROWS IN A S.NO COLUMN IN EXEL SHEET

Help Studio
, ,
1

HOW TO COUNT NUMBER OF ROWS IN A S.NO COLUMN IN EXEL SHEET

2

Hi @poojaskyrathore

Please try this,

  1. Read the excel sheet data in the datatable variable name dt.

  2. Use a message box and try this syntax,

dt.asenumerable.select(function(d) d("S.No").tostring).count

Thanks

3

Hi
Use the Read Range Activity and insert a Datatable (“myDatatable”) in Output property.
You can get the number of rows using myDatatable.Rows.Count.