Akbar, I think this will work for you...
Attached is the excel sheet with the values you specified in the email
download the sheet to desktop..
*the code is here*
datatable.AddSheet ("duplicate")
datatable.ImportSheet "C:\Documents and
Settings\ramchander\Desktop\excelqtp.xls",1,3
row_count = datatable.GetSheet(3).GetRowCount
low = 1
For current = low to row_count
datatable.GetSheet(3).SetCurrentRow(current)
value_dup = datatable.Value("sheet","duplicate")
If instr(ltr,value_dup)<= 0 Then
ltr = ltr & value_dup &","
End If
Next
msgbox left(ltr,len(ltr)-1)
Only unique values would print...
--
Regards
Shashidhar
+91 -8125564879
[email protected]
On Wed, Apr 18, 2012 at 8:44 PM, akbar basha <[email protected]>wrote:
> Hi All,
>
> This is an interview question,
>
> Please helpout in this.
>
> Suppose i have an excel excelqtp.xls ans column A with below values
>
> Column A
> -------
> A
> B
> C
> A
> B
> D
> E
> F
> C
>
> i want to fetch only individual value. The repeated values should not
> comes
> and also compare if values.
>
> Thanks in Advance
>
> --
> 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
excelqtp.xls
Description: MS-Excel spreadsheet
