Use Datatable.ExportSheet
On Mon, Apr 15, 2013 at 8:45 PM, Zak Shah <[email protected]> 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] > 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. > > > -- 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.
