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
