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