# How to use python library(openpyxl)in ignition 8 scripting **URL:** \ **Category:** Ignition\ **Tags:** scripting\ **Created:** [July 11, 2020, 1:40pm UTC](https://forum.inductiveautomation.com/t/how-to-use-python-library-openpyxl-in-ignition-8-scripting/36603 "2020-07-11T13:40:44Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [July 11, 2020, 2:13pm UTC](https://forum.inductiveautomation.com/t/how-to-use-python-library-openpyxl-in-ignition-8-scripting/36603/4 "2020-07-11T14:13:46Z")
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](https://inductiveautomation.com/moduleshowcase/module/kymera-systems-inc-kymera-office-document-module). There are [numerous discussions on this forum](http://forum.inductiveautomation.com/search?q=apache%20poi) 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](http://forum.inductiveautomation.com/t/using-openpyxl-3rd-party-python-library/32785): > > Hello, I’m trying to get openpyxl to work with Jython. I’ve followed steps from: [[Procedure for installing python libraries from source](http://forum.inductiveautomation.com/t/procedure-for-installing-python-libraries-from-source/26022)]([http://Installing](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 … --- _[View the full topic](https://forum.inductiveautomation.com/t/how-to-use-python-library-openpyxl-in-ignition-8-scripting/36603)._