+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Code issue (/Thread-Code-issue)
RE: Code issue - 1981.madhu@gmail.com - 11-05-2009
Thanks to all.My code is resolved.Closing the Thread.
[/color]
RE: Code issue - Saket - 11-05-2009
Always make a habbit to put your solutions here. that may help others.
RE: Code issue - 1981.madhu@gmail.com - 11-09-2009
Really i forgot .Simple i forgaot to giving the sheet name on excel sheet .By default its take sheet1 ,but i given sheet2.
Code:
datatable.AddSheet("newsheet")
datatable.ImportSheet "c:\tdf\spreadsheet.xls","[color=#FF0000]sheet2[/color]","newsheet"
n=datatable.GetSheet("newsheet").getrowcount
For i = 1 to n
datatable.SetCurrentRow(i)
flag=datatable.value("Flag","newsheet")
If flag = "y" Then
scriptpath=datatable.Value("Script_Path","newsheet")
objpath=datatable.Value("Repository_Path","newsheet")
executefile scriptpath
End If
Next