Christian has posted 9 posts at DZone. View Full User Profile

Obba 3.0: A Java Object Handler for Spreadsheets (for Client/Server Spreadsheet Add-Ins)

03.19.2012
| 1582 views |
  • submit to reddit

Obba iconObba provides a bridge between spreadsheets and Java classes. With Obba, you can use spreadsheets as GUIs for your Java libraries; turning your Java library to platform independent spreadsheet add-ins. Compatible with Excel/Windows, OpenOffice/Win/Mac/Linux, LibreOffice/Win/Mac/Linux, NeoOffice/Mac.

Its main features are: Obba Diagram
  • Stateful access to almost all objects and methods running in a Java virtual machine via a fixed set of spread sheet functions.
  • Client/server support: The Java virtual machine providing the add-in may run on the same computer or a remote computer - without any change to the spreadsheet.
  • Loading of arbitrary jar or class files at runtime through a spreadsheet function.
  • Instantiation of Java objects, storing the object reference under a given object label.
  • Invocation of methods on objects referenced by their object handle, storing the handle to the result under a given object label.
  • Asynchronous method invocation and tools for synchronization, turning your spreadsheet into a multi-threaded calculation tool.
  • Allows arbitrary number of arguments for constructors or methods (avoids the limitation of the number of arguments for Excel worksheet functions).
  • Serialization and de-serialization (save Serializable objects to a file, restore them any time later).
  • All this though spreadsheet functions, without any additional line of code (no VBA needed, no additional Java code needed).
For a tutorial see Obba tutorial. In this tutorial you create a Java class and a spreadsheet to fetch Stock quotes from finance.yahoo.com.
For a more detailed introduction see Obba documentation and Obba home page.

Version 3.0.2 of Obba is a major revision and brings support for running the Java virtual machine references in the spreadsheet on a different machine.

0
Average: 5 (1 vote)
Published at DZone with permission of its author, Christian Fries.

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Comments

Christian Fries replied on Sun, 2012/03/25 - 3:08am

If you have / had problems registering the DLL for Excel 2010 64 bit, please update to version 3.0.5 (or better).

 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.