ok.. so I think my above sudo code should work with little bit of modification.
On Jul 15, 5:56 am, chaman kalra <[email protected]> wrote: > there a only one column in the excel sheet called links which contain 5000 > links i.e. 5000 rows > > > > On Fri, Jul 15, 2011 at 11:57 AM, uma mahesh <[email protected]> wrote: > > First let me know, how the links in the excel sheet are > > How many rows are there and how many columns are there and in which > > way you would like to retrive > > I have a code but based on your requirement I can edit I will Provide > > _________________________________________________________________ > > > On Fri, Jul 15, 2011 at 9:56 AM, chaman kalra <[email protected]> > > wrote: > > > hi bhavin > > > > Requirement is i have a excel sheet which contains 5000 links. We have to > > > run each link in to the browser and record the response against each link > > in > > > the excel sheet. > > > > i hope its clear > > > > On Fri, Jul 15, 2011 at 1:20 AM, bhavin v patel <[email protected]> > > wrote: > > > >> I can provide you sudeo code for that > > > >> 1. "i need to check every link" question here is that want to u > > >> compare with another sheet or runtime object value ?? > > > >> DataTable.ImportSheet Import your sheet into script > > > >> rowCount=Datatable.GetSheet().GetRowCount > > > >> For i=0 to rowCount-1 > > > >> DataTable.GetSheet().SetNextRow > > > >> expectedValue=DataTable("ColumnName",sheetName) > > > >> actualValue=Object.GetROProperty(attribute) > > > >> If StrComp(expectValue,actualValue,1)=0 Then > > >> DataTable("Result", SheetName)= "Pass" > > >> '"we need to placed every link in a browser" > > >> Object.Set(expectedValue) ' set value inside address box > > >> "validate the response" > > >> Object.Click ' Go Button > > >> resonseValue=serverObject.GetROProperty(atibute) ' get response > > >> value > > >> If InStr(1,responseValue,"error)>0 Then > > >> DataTable("Result2",sheetname)="Link Failed" > > >> End IF > > >> End IF > > >> Next > > > >> There are so many different way to perform this action but u have to > > >> give out requirement properly :) > > > >> On Jul 14, 1:00 pm, chaman kalra <[email protected]> wrote: > > >> > Hello Group Members, > > > >> > I have 5000 links containing in a excel. i need to check every link. > > We > > >> > need > > >> > to placed every link in a browser and validate the response. If > > >> > response > > >> > received by the server is error code. link failed. We have to record > > the > > >> > output in the excel sheet > > > >> > Kindly help to provide the script for the same. > > > >> > -- > > >> > Thanks & Regards > > >> > Chaman Kalra > > >> > Internet Email :[email protected] > > > >> > ============== > > >> > *Dhan Nirankar Ji* > > > >> -- > > >> 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 > > > > -- > > > Thanks & Regards > > > Chaman Kalra > > > Internet Email :[email protected] > > > > ============== > > > Dhan Nirankar Ji > > > > -- > > > 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 > > -- > Thanks & Regards > Chaman Kalra > Internet Email :[email protected] > > ============== > *Dhan Nirankar Ji* -- 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
