Excel Documents

DataNucleus supports persisting objects to Excel documents (using the datanucleus-excel plugin). It makes use of the Apache POI project. Support for Excel is in its early stages and will be enhanced in future releases. If you wish to help out in this effort either by contributing or by sponsoring particular functionality please contact us via the DataNucleus Forum.

Datastore Connection

DataNucleus supports the following mode of operation, file-based

The following persistence properties will connect to a local file on your local machine

datanucleus.ConnectionDriverName=
datanucleus.ConnectionURL=excel:file:D:/myworkspace/test.xls
datanucleus.ConnectionUserName=
datanucleus.ConnectionPassword=


Known Limitations

The following are known limitations of the current implementation

  • Relationships between objects are not supported currently and wouldn't be easy to support since Excel doesn't have the concept of a relation
  • Datastore Identity is not currently supported
  • Optimistic checking of versions is not supported
  • Identity generators that operate using the datastore are not supported