Hi
I am wondering if it is possible to use Ranorex to record gestures in Excel. I need to be able to automate clicking on cells and using Pivot Tables. I tried installing the demo version and recording cell clicks but it seems to treat the entire spreadsheet as one large element instead of treating each cell as their own element.
Excel automation
- Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
- Contact:
Re: Excel automation
Hi,
The current version of Ranorex (V2.2.2) does not recognise the individual cells of the worksheets. However, we are in the process of adding support for this. The Ranorex plug-in should be available in beta form, by request in the next three weeks. and it will also be included and shipped with V2.3 by the end of march.
Regards,
Ron
Support Team
The current version of Ranorex (V2.2.2) does not recognise the individual cells of the worksheets. However, we are in the process of adding support for this. The Ranorex plug-in should be available in beta form, by request in the next three weeks. and it will also be included and shipped with V2.3 by the end of march.
Regards,
Ron
Support Team
Re: Excel automation
Instead of from the GUI you can access the Excel COM object and manipulate data. Specifically for the pivot tables take a look at the PivotField Object.
Try starting from here http://msdn.microsoft.com/en-us/library ... e.11).aspx and see if it gets you going in the right direction.
Try starting from here http://msdn.microsoft.com/en-us/library ... e.11).aspx and see if it gets you going in the right direction.
If this or any response has helped you, please reply to the thread stating that it worked so other people with a similar issue will know how you fixed your issue!
Ciege...
Ciege...
- Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
- Contact:
Re: Excel automation
The new Ranorex plug-in for Excel that Ron mentioned will also use this way.Ciege wrote:Instead of from the GUI you can access the Excel COM object and manipulate data.
Regards,
Alex
Ranorex Support Team