Delete a Row from the Datatable
In my QTP script when it copy data from the database to the data table, it adds a blank row to the end of the data table.
How can I tell if the last row on the data table is blank and then delete that row?
Or there is a where I can prevent QTP creating an extra row when copying data to the data table from the database.
Any help would be great!!
Re: Delete a Row from the Datatable
I found out why i have the blank row in my data table. The excel sheet that I imported into the data table the original data sheet had borders in the row so when I ran the code QTP thinks that the last row had data in it.
So I deleted the rows from the Original Excel sheet, imported it again and the script ran successfully.
So, in the future if anyone of you imported an excel sheet and use the row count, plus see a black line in the cell. Check your original Excel file for borders.
I hope this helps!!