Ranorex Forum

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.

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

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.

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