Need to extract the row count from an excel

need to extract the row count from an excel from the column A excluding the header , can someone please assist

Hi @JOBIN_JOSE

→ If the excel is read as Datatable, then you can try it with Datatable.Rows.Count
→ If you are using the excel activities you can use the Find First\Last Row Data Row activity, this activity gives the row number of the last row.

Hope it helps!!

1 Like

Hi @JOBIN_JOSE

In Read Range Workbook activity uncheck AddHeaders option

Hope this helps!!

1 Like

Hi
In ‘Read Range Workbook’ activity uncheck AddHeaders option and
Assign activity:
rowCount = yourDataTable.Rows.Count
Try this

Thank you

1 Like

@JOBIN_JOSE

Try this

  1. Use excel file activity and procide the excel path
  2. Inside that use Excel.Sheets("SheetName").RowsCount-1

Cheers

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.