The primary objective of WDS-JniPMML-XLL is to provide model evaluators to Excel. In particular, access to the standard PMML evaluator is a starting point, both for use and/or for comparison. Later versions will be include other model specs and implement other evaluators.
See documentation articles for a brief introduction.
- A pair of Excel AddIns (XLLs) and VBA support for:
- Evaluating PMML models
- As an Excel function call
- Using the de facto standard implementations
- Using input data from an in-worksheet table Uses XmlMap'd exportable ListObjects, but provides tools to facilitate
- Can evaluate one or multiple observations (rows) per call
- Results returned as normal function outputs
- With cachable models for efficiency
- Additional data wrangling tools for
- Importing/Exporting HDF5 compound datasets
- Importing/Exporting flat files
- Additional VBA module handling
- A Java wrapper of jpmml.evaluator
- Callable from the XLL via jni
- Testable as a standalone from the command line But, can be called through the Excel AddIn using the JVM.
- Input and output data can be:
- HDF5 compound datasets
- Flat files
- In memory (as when called through jni)
- Examples are included
- A test workbook and launch .bat to run the AddIns without installing
- A test set of the usual PMML cases
- 64 bit Excel Although, if compiling, 32 bit could possibly be added.
- Access to the VBA project object model (if using the VBA module handlers
- HDF5 and HDFView
- The HDF5 and HDFView libs are required if compiling, but the functionality could be removed.
- The provided jars require at least HDFView be on the path or the path passed in as a command line option when starting Excel
- Java jdk-12 Required when using the latest HDFView install.
- Compiling environment The github configurations are for Visual Studio Community Edition and Intellij Community edition.
- DocFx DocFx is used for the documentation build, including DocFxDoclet on the JavaDoc side.
All code contributions and development from Wypasek Data Science, Inc. (WDataSci) published on its public github site is released under the MIT license. Code from other sources is noted as such, and any assemblies, XLL's, and/or jars that may contain other software (for example, as Apache's Maven or ExcelDna may bundle from other sources) are released along with the commonly used IDE project and/or solution files used to generate them.