Need Help: Missing Run-Time Data Table in Result

[john.doe]

Hi All,

I'm currently developing a QTP test for SAP. The logic of the test is as described below:

Code:

DataTable.ImportSheet "..\SheetA.xls","1","SheetA"

rows = int(DataTable.GetSheet("SheetA").GetRowCount)

idx = int(1)

while idx <= rows

'execute transaction
DataTable("Status","SheetA") = 'result of the transaction

idx = idx + 1

wend

I execute the test in one iteration only, since I iterate all rows with 'While' loop. At the end of each time I run the test, run-time data table is missing and the Default.xls in result folder cannot be opened because it's somehow corrupted.

I've tried to change the program logic by erasing the 'While' loop and execute the test in multiple iterations, and the problem still persist.

Please help me to resolve this problem, guys.

Thank you,

john.doe