I tried without using excel file .I tried in datatable so i got some code error anyway at last i got it.Thanks you so much for ur reply.
On Thu, Apr 19, 2012 at 12:18 AM, shashi qa <[email protected]> wrote: > Chandana, > Its working fine for me please change the path of the excel file in the > code and try... > Please see the attached screenshot for your review... > > > Regards > > Shashidhar > +91 -8125564879 > [email protected] > > > > On Thu, Apr 19, 2012 at 2:10 AM, CHANDANA vodlakonda < > [email protected]> wrote: > >> Hi shashi, >> i tried ur below code its not working.it showing error at >> datatable.addsheet("duplicate").can u explain what is duplicate >> >> >> On 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 >> > > > > -- > > > -- > 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
