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.
