How to get excel row count

Excel row count can be get by using the following function:

function get_row_count(path,sheet)

dim inputdata

dim rowc

set inputData = DDT.ExcelDriver(path, Sheet)

while not inputdata.EOF

inputdata.Next

rowc = rowc+1

Wend

get_row_count = rowc

end Function