Home Applications Apache POI

Apache POI

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
0
0 reviews
0
Awards
230
Views
0
IPM installs
0
1
Details
Releases
Reviews
Issues
Pull requests
ObjectScript part for apache-poi integration

What's new in this version

Initial Release

apache-poi-os

ObjectScript part for apache-poi integration. Allows reading xlsx.

Installation

  1. Download latest release and import it into any namespace.
  2. Download java files: poi archive and poi.jar from latest release.
  3. Extract archive and copy poi.jar into one directory, later referenced as <DIR-WITH-JARS>. Caché should have access to this directory.
  4. Execute: set ^POI("DIR")=##class(%File).NormalizeDirectory("<DIR-WITH-JARS>")
  5. Create Java Gateway: Write $System.Status.GetErrorText(##class(isc.poi.Utils).createGateway(name, home, path, port)), where:
    • name is a name of the Java Gateway, defaults to POI.
    • home path to Java 1.8 JRE. Defaults to JAVA_HOME environment variable.
    • path is a path to jars, should be set automatically.
    • port Java Gateway port. Defaults to 55556.
  6. Load jar into Caché: Write $System.Status.GetErrorText(##class(isc.poi.Utils).updateJar())
  7. Check that everything works: Write $System.Status.GetErrorText(##class(isc.poi.Utils).getBook(file, .book))

API

Excel books are loaded into isc.poi.Book objects. Check it for API documentation.

Version
1.0.016 Oct, 2019
Category
Integration
Works with
EnsembleInterSystems IRIS
First published
16 Oct, 2019