10-09-2019, 03:55 PM
I have added new shhet and imported excel data in that sheet.
iteration=datatable.GetSheet(3).GetRowCount
There are 4 rows in my sheet. Script is running after 4th iteration taking blank data.
when i displayed total count writing as 'msgbox iteration', it is showing 999 rows
iteration=datatable.GetSheet(3).GetRowCount
There are 4 rows in my sheet. Script is running after 4th iteration taking blank data.
when i displayed total count writing as 'msgbox iteration', it is showing 999 rows