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
-~----------~----~----~----~------~----~------~--~---
