Hi Sujith
My Requirement:
Click on weblink(link to open excel sheet)
click on open winbutton
validate the Column names
How to work in order of validating the column names in an opened excel file
at run time
can you post solution for this ??
Thanks in Advance!!
--with regards
Rakesh :)
On Tuesday, May 22, 2012 11:48:31 PM UTC+5:30, sujit wrote:
>
> 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]
> <javascript:>>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]<javascript:>
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>
>> 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
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
