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
