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.