Obba provides a bridge from spreadsheets to Java classes. With Obba, you can easily build spreadsheet GUIs (Excel or OpenOffice) to Java code. Its main features are:
* Loading of arbitrary jar or class files at runtime through an 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 the Obba documentation
Components
Obba is small.
Obba for Excel consists of three files (these files will be installed by an an installer Install Obba for Excel.exe):
* Obba.xla: An Excel Add-in providing workbook functions like obMake(), obCall(), obGet().
* Obba.dll: The bridge from Excel to Java.
* Obba.jar: The Java object handler and the Obba control panel.
Obba for OpenOffice consists of one file:
* Obba.oxt: The Obba Add-in including the OpenOffice adapter and Obba.jar (the Java object handler and the Obba control panel).
Thank you for your interest in Bean Sheet -- an interpretive Java spreadsheet utilizing Java spec syntax. At its core is Bean Shell, an open source Java interpreter. Because Bean Shell has full access to the Java Virtual Machine, the potential of marrying a Java interpreter with the concepts of a spreadsheet application is beyond and different from traditional spreadsheet software. Each Bean Sheet document can be a powerful application in its own right.