How many rows in the Excel

Help
1

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.

2

Hi,

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

image
image1886×825 63 KB

Thanks,
Aisling

3

Thank you for your kindness
solve it !!!

4

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