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

[yifeiliu08]

I currently study the python 3.7 that have a function use excel, so i need first pip install openpyxl this module in my computer

in the program i can import the module by import openpyxl

my question , if in ignition 8, if i want to use the python library (for example the openpyxl), how to set the module then i can directly import openpyxl in my scripting

[pturmel]

You cannot. Jython 2.7 is significantly different from Python 3.7.

[yifeiliu08]

python’s default library is not so much, but python have a big advantage is he can import a lot of library
my question is if Jython 2.7 have the same function like python, import other library, if yes, can you introduce some information about how to do in that way

[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 …

[yifeiliu08]

thanks pturmel’s input, there really many information to read, i will use time to understand old discussion
i have downlad the kymera’s office driver want to have a trial run
but after i install , if i open the designer, it will report the fault

this is the first time i try to use ignition’s 3rd party module, i don’t know this module can be directly use or need some api to link

[pturmel]

Haven’t seen that problem. You’ll probably need help from Kymera’s support.

[yifeiliu08]

i will test them when my plant shut down , because this module make all of my client crash, a big surprise

[pturmel]

Wait! Your are playing around with a production system?

Don’t do that. Set up an isolated VM with the same stuff as your production system and use that. In trial mode.

[drojas]

This happened to me too. A reboot of the computer fixed it. Since you are in production, I would schedule some downtime to perform a restart of Ignition or the entire PC.

[yifeiliu08]

i install on a trial system, and restart that pc, but still have found that fault

[Eden.Mar]

Hi yifeiliu08,

Thank you for your interest in our module. If you would forward a screenshot of the full stack trace, and the build number of the module to support@kymerasystems.com, we’d be happy to further assist you.