This component (
isis-wicket-excel) allows a collection of entities to be downloaded as an Excel spreadsheet (using Apache POI).
The module’s functionality can be explored by running the quickstart with example usage using the
A home page is displayed when the app is run:
The module contributes an additional "view" for both standalone and parented collections:
Then the standalone collection of all incomplete todo items shows an additional link to select the excel view:
In both cases this view is simply a button to download the collection as an Excel spreadsheet:
And the spreadsheet contains the contents of the collection:
Simply add this component to your classpath, eg:
<dependency> <groupId>org.isisaddons.wicket.excel</groupId> <artifactId>isis-wicket-excel-cpt</artifactId> <version>1.15.0</version> </dependency>
You should then find that a new view is provided for all collections of entities (either as returned from an action, or as a parented collection), from which a link to download the spreadsheet can be accessed.
Check for later releases by searching Maven Central Repo.
For instructions on how to use the latest
-SNAPSHOT, see the contributors guide.
None known at this time.
See also the Excel library module, which provides programmatic ability to export or import objects to/from an Excel spreadsheet.
Maven can report modules dependencies using:
mvn dependency:list -o -pl modules/wkt/excel/impl -D excludeTransitive=true
which, excluding Apache Isis itself, returns these compile/runtime dependencies:
org.apache.poi:poi:jar:3.9 org.apache.poi:poi-ooxml-schemas:jar:3.9 org.apache.poi:poi-ooxml:jar:3.9
For further details on 3rd-party dependencies, see: