Hi Omkar,
Set objExcel = CreateObject("Excel.Application")
Set objWorkBook = objExcel.Workbooks.Open ("C:\temp\Salary.xls")
Set objSheet = objExcel.Sheets("Sheet1")
Set Cells=objSheet.Cells
'Find Cell Position of "Column_Name
Set objvalueFind=objSheet.UsedRange.Find("Column_Name")
If Not objvalueFind is Nothing Then
sAddress=objvalueFind.Address
aRowCol=Split(sAddress,"$",-1,1)
End If
'In this way you can get name/position of Column and "aRowCol" Variable
contain number of column
Same think you can do for to get Row number then combine both and enjoy :)
Feel free to ask if you have any query :)
--
Thanks & Regards
Sujit :)
On Tue, May 22, 2012 at 1:19 PM, omkar <[email protected]> wrote:
> Hi All,
>
> I am working with Excel Object in QTP.
>
> I want to get the Excel cell content using Column Name, Row Name.
>
> Is there a way to do that.
>
> OBJEXCELWORKSHEET.cell(RowName, ColumnName)
>
> In RowName and ColumnName I want to provide the names instead of numbers.
>
> --
> Thanks & Regards,
> Omkar Deekonda
> +91 9986519903
>
> --
> 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
>
--
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
