Excel automation

Ask general questions here.
jamesd
Posts: 1
Joined: Thu Feb 04, 2010 8:53 pm

Excel automation

Post by jamesd » Thu Feb 04, 2010 8:58 pm

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.

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: Excel automation

Post by Support Team » Fri Feb 05, 2010 3:28 pm

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
.
Image

User avatar
Ciege
Ranorex Guru
Posts: 1335
Joined: Thu Oct 16, 2008 6:46 pm
Location: Arizona, USA

Re: Excel automation

Post by Ciege » Mon Feb 08, 2010 6:52 pm

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.
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...

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: Excel automation

Post by Support Team » Tue Feb 09, 2010 10:57 am

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
.
Image