Excel Documents

DataNucleus supports persisting/retrieving objects to/from Excel documents (using the datanucleus-excel plugin). It makes use of the Apache POI project. If you wish to contribute to this plugin either by contributing or by sponsoring particular functionality please contact us via the DataNucleus Forum.

Datastore Connection

DataNucleus supports file-based Excel datastores currently.

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

datanucleus.ConnectionURL=excel:file:myfile.xls

replacing "myfile.xls" with your filename, which can be absolute or relative.

So you create your PersistenceManagerFactory or EntityManagerFactory with these properties. Thereafter you have the full power of the JDO or JPA APIs at your disposal, for your Excel datastore.



Queries

Access Platform allows you to query the objects in the datastore using the following

  • JDOQL - language based around the objects that are persisted and using Java-type syntax
  • JPQL - language based around the objects that are persisted and using SQL-like syntax