How to use python library(openpyxl)in ignition 8 scripting

[pturmel]

I've just checked the requirements for openpyxl--there are transitive (optional?) dependencies on CPython native DLLs. Those can't be made to work in a JVM. You'll have to retool your scripts to use a java library for document manipulation. Apache POI is a popular choice, and happens to be part of Kymera's Office Document Module.

There are numerous discussions on this forum describing the use of Apache POI, including commentary on its use as an alternative to openpyxl.

There's also a report of partial success with an older version of openpyxl. Might want to try that:

Using Openpyxl 3rd party python library

Hello, I’m trying to get openpyxl to work with Jython. I’ve followed steps from: [Procedure for installing python libraries from source](http://Installing 3rd party python libraries) and have used pip to install openpyxl using jython2.7.1. I can even see it in Ignition when I do help(“modules”). When I try to import openpyxl I get this error, even though I know that datetime functions work… there is a datetime.py in that cache folder… maybe that’s messing it up. Any luck with this? thanks …