Obba provides a bridge between spreadsheets and Java classes. With Obba, you can use spreadsheets as GUIs (Graphical User Interfaces) for your Java libraries. Its main features are:

• 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 more detailed introduction see Obba homepage.
See Obba Tutorial for a demo sheet showing how to access data from finance.yahoo.com. Includes the Java source code for the class handling the web access.
See http://www.obba.info/#issues for known bugs.
See http://www.finmath.net/spreadsheets/ for an application using Obba.

Version: 2.2.15

Report abuse here