# Using 3rd party Python Libraries

**URL:** <https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765>\
**Category:** Ignition\
**Tags:** ignition79, scripting\
**Created:** [April 18, 2018, 8:35pm UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765 "2018-04-18T20:35:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![josh.kohut](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@josh.kohut](https://forum.inductiveautomation.com/u/josh.kohut)\
**Post date:** [April 18, 2018, 8:35pm UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765/1 "2018-04-18T20:35:03Z")

</div>

Hello, I am trying to parse a xlsx file in a script. I know there are various libraries which can do this but the one I was trying to use is openpyxl. I know Ignition supports 3rd party libraries by putting them into the Ignition python library folder. However, this library does not work when simply extracted into the directory. It has installer files and I think that it has to be installed to work correctly. I was wondering if anyone had any advice on how I can use this library inside of Ignition or other ways to parse an xlsx file.

Thanks!

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [April 18, 2018, 8:49pm UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765/2 "2018-04-18T20:49:52Z")

</div>

I don’t think your chosen library will be compatible with Ignition.

Ignition uses Jython 2.5. The openpyxl project seems to have dependencies in numpy and pandas, which both rely on CPython native extensions.

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [April 18, 2018, 9:01pm UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765/3 "2018-04-18T21:01:12Z")

</div>

[requirements.txt](https://bitbucket.org/openpyxl/openpyxl/src/7e42546674ebeb0e518d1a058abbb1a6d6f7fd1c/requirements.txt?at=default&fileviewer=file-view-default) outlines many incompatible dependencies

[setup.py](https://bitbucket.org/openpyxl/openpyxl/src/7e42546674ebeb0e518d1a058abbb1a6d6f7fd1c/setup.py?at=default&fileviewer=file-view-default) calls for python versions of 2.7+

I’ve used this [3rd party module](http://www.perfectabstractions.com/pa-office-document-module.html) from @nmudge before for reading and writing to Excel files. It provides nice wrappers for Apache POI library.

---

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [April 20, 2018, 3:19pm UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765/4 "2018-04-20T15:19:07Z")

</div>

You can use “xlsxwriter” library.  
It’s the only python library compatible with Jython 2.5  
There is only one issue… it only creates excel file. It is not possible to edit ad already existing file, you will have to create a new file every time.  
Just download it from the [pypi.com](http://pypi.com) page  
And here it is the knowledge base [http://xlsxwriter.readthedocs.io/index.html](http://xlsxwriter.readthedocs.io/index.html)

---

<div class="post-metadata">

**Author:** ![josh.kohut](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@josh.kohut](https://forum.inductiveautomation.com/u/josh.kohut)\
**Post date:** [April 20, 2018, 3:31pm UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-libraries/17765/5 "2018-04-20T15:31:18Z")

</div>

Thanks, I used this linked 3rd party module here and it worked great.