kaiiii
5 years agoRegular Contributor
Solved
How can I Count the row of test data in my excel sheet.
How can I Count the row of test data in my excel sheet. Like: Project.Variable.VariableName.IsEOF ---> used to check sheet is empty or not Project.Variable.VariableName.ColumnCount --> used to ...
- 5 years ago
There is no function/method/property of the DB Table variable type that will give you the explicit row count. So, you'll need to write code to do so.
function sheetText(){ var rowCount rowCount = 0 while (!Project.Variables.VariableName.IsEOF()) { rowCount++ Project.Variables.VariableName.Next() } Log.Message(rowCount) }