Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Jubula » control Excel?(question about Jubula control of Excel)
control Excel? [message #945123] Mon, 15 October 2012 08:52 Go to next message
Erik Gilbert is currently offline Erik GilbertFriend
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 Go to previous messageGo to next message
Achim Loerke is currently offline Achim LoerkeFriend
Messages: 357
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
Re: control Excel? [message #945190 is a reply to message #945135] Mon, 15 October 2012 09:34 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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 Go to previous messageGo to next message
Achim Loerke is currently offline Achim LoerkeFriend
Messages: 357
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
Re: control Excel? [message #945366 is a reply to message #945319] Mon, 15 October 2012 11:15 Go to previous messageGo to next message
Erik Gilbert is currently offline Erik GilbertFriend
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?



Re: control Excel? [message #945438 is a reply to message #945366] Mon, 15 October 2012 11:54 Go to previous messageGo to next message
Achim Loerke is currently offline Achim LoerkeFriend
Messages: 357
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
Re: control Excel? [message #945624 is a reply to message #945438] Mon, 15 October 2012 13:37 Go to previous message
Erik Gilbert is currently offline Erik GilbertFriend
Messages: 55
Registered: September 2010
Member
Ok. I see. Thanks for the help!
Previous Topic:No valid Java binary found
Next Topic:Pause during test execution?
Goto Forum:
  


Current Time: Sun Dec 21 17:28:30 GMT 2014

Powered by FUDForum. Page generated in 0.02427 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software