i did that however it only record under Global table, When i try to record under Action1 it doesn't record / Save values under any table. Do i need to rename all the field dtAction1 ?
On Monday, April 15, 2013 10:24:24 PM UTC-4, Ganesh muralidharan wrote: > > Use Datatable.ExportSheet > > > On Mon, Apr 15, 2013 at 8:45 PM, Zak Shah <[email protected]<javascript:> > > wrote: > >> Now wanted to export data into a new sheet or now excel sheet to avoid >> overwrite situation >> >> >> On Saturday, April 13, 2013 3:29:28 AM UTC-4, Zak Shah wrote: >>> >>> thanks man working >>> >>> On Saturday, April 13, 2013 3:14:04 AM UTC-4, Ganesh muralidharan wrote: >>>> >>>> Try file name with .xls extension >>>> >>>> On Apr 13, 2013, at 2:03 AM, Zak Shah <[email protected]> wrote: >>>> >>>> When i add Datatable.export("C:\**Users\n\Desktop\saa.xlsx") at the >>>> end . after the run time when i try to open the excel file it gives me >>>> error. and doesn't open >>>> >>>> On Saturday, April 13, 2013 2:26:29 AM UTC-4, Zak Shah wrote: >>>>> >>>>> Can you help me >>>>> >>>>> On Saturday, April 13, 2013 2:15:31 AM UTC-4, Ganesh muralidharan >>>>> wrote: >>>>>> >>>>>> Did you try Datatable.export or Datatable.exportsheet >>>>>> >>>>>> >>>>>> On Sat, Apr 13, 2013 at 1:09 AM, Zak Shah <[email protected]> wrote: >>>>>> >>>>>>> Dim bro, url, image >>>>>>> >>>>>>> bro = "iexplore" >>>>>>> url = >>>>>>> "http://www.chevrolet.com/**tools/help-choose-vehicles.**html<http://www.chevrolet.com/tools/help-choose-vehicles.html> >>>>>>> " >>>>>>> systemutil.Run bro, url >>>>>>> browser("title:=.*").Sync >>>>>>> wait 2 >>>>>>> DataTable.GetRowCount >>>>>>> i=1 >>>>>>> >>>>>>> Set mypage=browser("title:=.*").**page("title:=.*") >>>>>>> >>>>>>> >>>>>>> While mypage.image("class:=mm size_3","index:="&i).exist >>>>>>> mypage.Sync >>>>>>> wait 3 >>>>>>> >>>>>>> >>>>>>> >>>>>>> Datatable( "L1", dtGlobalSheet )= mypage.image("class:=mm >>>>>>> size_3","index:="&i).**getroproperty("filename") >>>>>>> Datatable( "L1", dtGlobalSheet )= mypage.image("class:=mm >>>>>>> size_3","index:="&i).**getroproperty("href") >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Set desc=description.Create >>>>>>> desc("micclass").value="**WebElement" >>>>>>> desc("class").value="tx_price" >>>>>>> Set obj=browser("title:=.*").page(**"title:=.*").ChildObjects(** >>>>>>> desc) >>>>>>> Datatable( "l2", dtGlobalSheet )= obj(0).getroproperty("** >>>>>>> innertext") >>>>>>> mypage.image("class:=mm size_3","index:="&i).click >>>>>>> mypage.Sync >>>>>>> wait 4 >>>>>>> >>>>>>> i=i+1 >>>>>>> >>>>>>> Set desc2=description.Create >>>>>>> desc2("micclass").value="**WebElement" >>>>>>> desc2("class").value="pf6a" >>>>>>> Set obj2=browser("title:=.*").**page("title:=.*").** >>>>>>> ChildObjects(desc2) >>>>>>> Datatable( "l3", dtGlobalSheet )=obj2(0).getroproperty("** >>>>>>> outertext") >>>>>>> >>>>>>> >>>>>>> Datatable.SetCurrentRow(i) >>>>>>> >>>>>>> wait 6 >>>>>>> browser("title:=.*").Back >>>>>>> >>>>>>> >>>>>>> >>>>>>> Wend >>>>>>> >>>>>>> >>>>>>> >>>>>>> Now i wanted to export to excel sheet from datatable can you guys >>>>>>> help? >>>>>>> >>>>>>> -- >>>>>>> -- >>>>>>> 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 >>>>>>> MercuryQTP+...@googlegroups.**com >>>>>>> For more options, visit this group at >>>>>>> http://groups.google.com/**group/MercuryQTP?hl=en<http://groups.google.com/group/MercuryQTP?hl=en> >>>>>>> >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "QTP - HP Quick Test Professional - Automated Software Testing" >>>>>>> group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to mercuryqtp+...@googlegroups.**com. >>>>>>> For more options, visit >>>>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>>>>> . >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> >>>>>> >>>>>> Ganesh Muralidharan >>>>>> 'God Never Forgets' >>>>>> >>>>> -- >>>> -- >>>> 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 >>>> MercuryQTP+...@googlegroups.**com >>>> For more options, visit this group at >>>> http://groups.google.com/**group/MercuryQTP?hl=en<http://groups.google.com/group/MercuryQTP?hl=en> >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "QTP - HP Quick Test Professional - Automated Software Testing" >>>> group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to mercuryqtp+...@googlegroups.**com. >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>> . >>>> >>>> >>>> >>>> -- >> -- >> 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]<javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> 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 Groups >> "QTP - HP Quick Test Professional - Automated Software Testing" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > Regards, > > > Ganesh Muralidharan > 'God Never Forgets' > -- -- 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 Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
