How many rows in the Excel

Hello every Community friends:
I have a question to ask you:
Look at the picture:%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(21)
How can I get the range number:16.
I mean I want know that How many rows in the Excel
Help me please.


You can read the sheet to datatable variable such as dt_test, then use dt_test.Rows.Count to get the row count.


Thank you for your kindness
solve it !!!

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