# Apache POI Import Error

**URL:** <https://forum.inductiveautomation.com/t/apache-poi-import-error/15228>\
**Category:** 3rd Party Modules\
**Created:** [September 1, 2017, 2:45pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228 "2017-09-01T14:45:14Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![TruThat](https://avatars.discourse-cdn.com/v4/letter/t/ea666f/32.png) [@TruThat](https://forum.inductiveautomation.com/u/TruThat)\
**Post date:** [September 1, 2017, 2:45pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/1 "2017-09-01T14:45:14Z")

</div>

So I have successfully created a script that runs from a button on a windows.

When I moved the script to a gateway Event Scripts on a tag change… I get this error

"com.inductiveautomation.ignition.common.script.JythonExecException: Traceback (most recent call last): File “”, line 1, in ImportError: No module named poi "

from this line of code.  
“from org.apache.poi.ss.usermodel import Row,Cell”

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [September 1, 2017, 2:58pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/2 "2017-09-01T14:58:36Z")

</div>

Apache POI isn’t available to use in the gateway.

That it’s even available in the client and designer is a quirk of how class paths work in the client and the fact that you have the reporting module installed.

---

<div class="post-metadata">

**Author:** ![TruThat](https://avatars.discourse-cdn.com/v4/letter/t/ea666f/32.png) [@TruThat](https://forum.inductiveautomation.com/u/TruThat)\
**Post date:** [September 1, 2017, 3:13pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/3 "2017-09-01T15:13:42Z")

</div>

Bummer. Would it work if I put it in the visionWindowOpened area?

---

<div class="post-metadata">

**Author:** ![cody.tamaki](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\
**Post date:** [September 22, 2017, 9:11pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/4 "2017-09-22T21:11:21Z")

</div>

I have a free module available that would make the Apache POI libraries available in scripts for your client/designer.

It’s called Tamaki Scripting and Available Here:  
[http://www.tamaki.co.nz/links/](http://www.tamaki.co.nz/links/)

---

<div class="post-metadata">

**Author:** ![accyroy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/accyroy/32/3386_2.png) [@accyroy](https://forum.inductiveautomation.com/u/accyroy)\
**Post date:** [September 23, 2017, 8:12pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/5 "2017-09-23T20:12:03Z")

</div>

Sounds good Cody, do you have any documentation on your scripting module?

Cheers

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 6, 2017, 7:10pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/6 "2017-10-06T19:10:25Z")

</div>

I’ll bump this once, in case you didn’t see it, Cody. 🙂

Also interested in documentation, if it’s available.

---

<div class="post-metadata">

**Author:** ![cody.tamaki](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\
**Post date:** [October 6, 2017, 7:30pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/7 "2017-10-06T19:30:14Z")

</div>

I didn’t see it thanks for the bump.

accyroy I’ll have to do some digging because I know I’ve got a document somewhere. The github repository is:  
[https://github.com/TamakiControl/TamakiScripting](https://github.com/TamakiControl/TamakiScripting) if you want to look for now. I’ll find that document and upload it here…

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [October 6, 2017, 8:00pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/8 "2017-10-06T20:00:56Z")

</div>

@cody.tamaki thanks for sharing this code. You could upload it to [https://github.com/IgnitionModuleDevelopmentCommunity](https://github.com/IgnitionModuleDevelopmentCommunity) !

---

<div class="post-metadata">

**Author:** ![cody.tamaki](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\
**Post date:** [October 6, 2017, 8:07pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/9 "2017-10-06T20:07:46Z")

</div>

I will do that. Do I need an invite from you? My github account is [https://github.com/cmwarre](https://github.com/cmwarre)

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [October 6, 2017, 8:49pm UTC](https://forum.inductiveautomation.com/t/apache-poi-import-error/15228/10 "2017-10-06T20:49:32Z")

</div>

I’m sure @Travis.Cox will invite you !
