Generating Word and Excel Files out of XPages was never easier
POI 4 XPages brings the Apache POI Project to the XPages developer community.
With Release 1.2.1 we ensured that POI 4 XPages can also be used under Domino 9.
A new feature is the styling and formatting of cells in Excel and the ability to use formulas.
It is possible to insert the value as a formula, which means you can benefit from the full range of excel formulas now.
Additional you can configure the style of cells within the poi properties and change the border, font, background and format as needed.
We have also fixed an issue introduced with version 1.2.0 where we started to use the POI Workbook Streamingmodell. Because of some disadvantages, you can now choose the streamingmodell as an option.
POI 4 XPages is a Extension like the ExtensionLibrary and need to be installed to the server and the client in the same way. Follow this instructions (after downloading POI4Xpages) and activate in the same way the biz.webgate.dominoext.poi.updatesite on your server and in your designer client.
See our installation guide: http://my.webgate.biz/poi/documentation.nsf/viewdoc.xsp?docid=installguide
See the full documentation: http://my.webgate.biz/poi.documentation
And additional infos from IBM: http://www-10.lotus.com/ldd/ddwiki.nsf/dx/XPages_Extension_Library_Deployment
The example database needs the ExtensionLibrary to run. See in the example database how you can use POI 4 XPages
Please report any issue to our github project: https://github.com/OpenNTF/POI4Xpages/issues
See any progress on this project directy on the github -> https://github.com/OpenNTF/POI4Xpages.