Page 1 of 1

Excel automation

Posted: Thu Feb 04, 2010 8:58 pm
by jamesd
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.

Re: Excel automation

Posted: Fri Feb 05, 2010 3:28 pm
by Support Team
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

Re: Excel automation

Posted: Mon Feb 08, 2010 6:52 pm
by Ciege
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.

Re: Excel automation

Posted: Tue Feb 09, 2010 10:57 am
by Support Team
Ciege wrote:Instead of from the GUI you can access the Excel COM object and manipulate data.
The new Ranorex plug-in for Excel that Ron mentioned will also use this way.

Regards,
Alex
Ranorex Support Team