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"; >>>>> 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 >>>>> [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. >> >> >> >> -- -- 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.
