Eclipse Community Forums: Jubula

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

Mon, 15 October 2012 04:52

Eclipse User

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 03:42] by Moderator

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

Mon, 15 October 2012 05:00

Eclipse User

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

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

Mon, 15 October 2012 05:34

Eclipse User

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 05:40] by Moderator

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

Mon, 15 October 2012 06:48

Eclipse User

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

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

Mon, 15 October 2012 07:15

Eclipse User

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?

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

Mon, 15 October 2012 07:54

Eclipse User

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

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

Mon, 15 October 2012 09:37

Eclipse User

Ok. I see. Thanks for the help!

Previous Topic:	No valid Java binary found
Next Topic:	Pause during test execution?

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 11:45:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter