Hi shashi,
i tried ur below code its not working.it showing error at
datatable.addsheet("duplicate").can u explain what is duplicateOn Wed, Apr 18, 2012 at 12:19 PM, shashi qa <[email protected]> wrote: > 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 > -- 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
