It works. Thanks a lot. Regards, Jagannath
On Tue, Jul 14, 2009 at 7:10 PM, Roman Zilber<[email protected]> wrote: > Try this function (I haven't debugged it) > > Function gExcelTable_GetParameterIndex(sheetName, paramName) > NumOfParameters = DataTable.GetSheet(SheetName).GetParameterCount > For Iterator = 0 To NumOfParameters - 1 Step 1 > > If DataTable.GetSheet(SheetName).GetParameter(Iterator).Name = > paramName Then > gExcelTable_GetParameterIndex = Iterator > Exit Function > End If > > Next > gExcelTable_GetParameterIndex = Null > End Function > > > > > On Tue, Jul 14, 2009 at 3:28 AM, Jagannath Prasad Padhy <[email protected]> > wrote: >> >> Hi All, >> >> Please let me know, In QTP, is there any way to find the column index >> if we give the column name. Suppose in my excel sheet I have 7 columns >> like Build Number,ModuleName,Test Case Name,MethodName, Execution >> Time,Expected Value and  Actual Value. How to find out the column >> index for column - "Expected Value". >> >> >> Regards, >> Jagannath >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -~----------~----~----~----~------~----~------~--~---
