# Using Openpyxl 3rd party python library

**URL:** <https://forum.inductiveautomation.com/t/using-openpyxl-3rd-party-python-library/32785>\
**Category:** Ignition\
**Created:** [March 3, 2020, 9:18pm UTC](https://forum.inductiveautomation.com/t/using-openpyxl-3rd-party-python-library/32785 "2020-03-03T21:18:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![downerczx](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/downerczx/32/11649_2.png) [@downerczx](https://forum.inductiveautomation.com/u/downerczx)\
**Post date:** [March 3, 2020, 9:18pm UTC](https://forum.inductiveautomation.com/t/using-openpyxl-3rd-party-python-library/32785/1 "2020-03-03T21:18:09Z")

</div>

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

Traceback (most recent call last):  
File “”, line 2, in   
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\__init_\_.py”, line 6, in   
from openpyxl.workbook import Workbook  
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\workbook\__init_\_.py”, line 4, in   
from .workbook import Workbook  
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\workbook\workbook.py”, line 7, in   
from openpyxl.worksheet.worksheet import Worksheet  
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\worksheet\worksheet.py”, line 24, in   
from openpyxl.cell import Cell, MergedCell  
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\cell\__init_\_.py”, line 3, in   
from .cell import Cell, WriteOnlyCell, MergedCell  
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\cell\cell.py”, line 28, in   
from openpyxl.utils.datetime import (  
File “C:\Users\controls.ignition\cache\gwlocalhost\_8088\C0\pylib\openpyxl\utils\datetime.py”, line 8, in   
from datetime import timedelta, tzinfo  
ImportError: cannot import name timedelta

---

<div class="post-metadata">

**Author:** ![Stevenson.Yuan](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@Stevenson.Yuan](https://forum.inductiveautomation.com/u/Stevenson.Yuan)\
**Post date:** [March 6, 2020, 10:24pm UTC](https://forum.inductiveautomation.com/t/using-openpyxl-3rd-party-python-library/32785/2 "2020-03-06T22:24:36Z")

</div>

Fairly certain it’s not vanilla python. Some of the inits import NUMPY and PANDAS which are CPython based. Unfortunately our Jython interpreter can’t handle Cpython libraries.

---

<div class="post-metadata">

**Author:** ![paula.talley](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@paula.talley](https://forum.inductiveautomation.com/u/paula.talley)\
**Post date:** [June 29, 2020, 6:27pm UTC](https://forum.inductiveautomation.com/t/using-openpyxl-3rd-party-python-library/32785/3 "2020-06-29T18:27:16Z")

</div>

Latest version of openpyxl doesn’t support python 2.7. I downloaded the last version that supports it and am using it successfully - version 2.6.4. Only issue is that is uses SAX XML parser, which isn’t available in Vision, only in Designer. So, having to run scripts on Gateway instead of Client.