Obba: A Java Object Handler for OpenOffice.
Join the DZone community and get the full member experience.Join For Free
obba provides a bridge from spreadsheets to java classes.
version 1.6 of the add-in is now available for openoffice 3.0. it implements the same java object handling api for openoffice as it does for excel. sheets may be migrated from excel to openoffice and back with little effort.
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).
Opinions expressed by DZone contributors are their own.