Thanks for All, Regards, Akbar
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
