Eclipse Community Forums: Jubula

Help

Home

Home » Archived » Jubula » control Excel?(question about Jubula control of Excel)

Show: Today's Messages :: Show Polls :: Message Navigator

control Excel? [message #945123]

Mon, 15 October 2012 08:52

Erik Gilbert

Messages: 55
Registered: September 2010

Member

my Jubula GUI test opens an Excel file. Can Jubula control an Excel file? Like for instance saving it or checking values in particular cells of the worksheet?

[Updated on: Tue, 16 October 2012 07:42]

Report message to a moderator

Re: control Excel? [message #945135 is a reply to message #945123]

Mon, 15 October 2012 09:00

Achim Loerke

Messages: 376
Registered: July 2009
Location: Braunschweig, Germany

Senior Member

To work with external data (like Excel) in Jubula tests you have to write an extension. Be advised that dealing with Excel from a Java program is not for the faint of heart.

Achim

Report message to a moderator

Re: control Excel? [message #945190 is a reply to message #945135]

Mon, 15 October 2012 09:34

Erik Gilbert

Messages: 55
Registered: September 2010

Member

isnt there a way to add the Jubula plug in to for instance Open Office and control the Open Office GUI in the same way as other GUI programs? Would it be possible for instance to GUI test Open Office with Jubula?

[Updated on: Mon, 15 October 2012 09:40]

Report message to a moderator

Re: control Excel? [message #945319 is a reply to message #945190]

Mon, 15 October 2012 10:48

Achim Loerke

Messages: 376
Registered: July 2009
Location: Braunschweig, Germany

Senior Member

I have no idea which GUI toolkit is used for Open Office. If it's among the toolkits supported by Jubula give it a try. You may recheck the list of toolkits with tomorrows new release.

Achim

Report message to a moderator

Re: control Excel? [message #945366 is a reply to message #945319]

Mon, 15 October 2012 11:15

Erik Gilbert

Messages: 55
Registered: September 2010

Member

I added the jubula plug-in to c:\Program Files (x86)\OpenOffice.org 3\Basis\program\classes\ and the config info for the plug-in to fundamentalbasis.ini in c:\Program Files (x86)\OpenOffice.org 3\Basis\program\

This seemed to be a logical place to add the plug-in. But trying to start Open Office from Jubula, I get the following error message:

c:\Program Files (x86)\OpenOffice.org 3\Basis\program\en_US does not exist.

There wasn't such a file in my other application which was able to use Jubula successfully. What is this en_US?

Report message to a moderator

Re: control Excel? [message #945438 is a reply to message #945366]

Mon, 15 October 2012 11:54

Achim Loerke

Messages: 376
Registered: July 2009
Location: Braunschweig, Germany

Senior Member

The plug-in is intended for Eclipse RCP applications. I'm quite sure OO isn't one.

After some google-ing I found that OO probably uses its own GUI toolkit called "Visual Class Library" or VCL for short. This looks like an abstract GUI toolkit written in C++. It is definitely not supported by Jubula.

Achim

Report message to a moderator