apache-poi-os

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

Installation

Download latest release and import it into any namespace.
Download java files: poi archive and poi.jar from latest release.
Extract archive and copy poi.jar into one directory, later referenced as <DIR-WITH-JARS>. Caché should have access to this directory.
Execute: set ^POI("DIR")=##class(%File).NormalizeDirectory("<DIR-WITH-JARS>")
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.
Load jar into Caché: Write $System.Status.GetErrorText(##class(isc.poi.Utils).updateJar())
Check that everything works: Write $System.Status.GetErrorText(##class(isc.poi.Utils).getBook(file, .book))

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