Apache POI Import Error

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”

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.

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

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/

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

Cheers

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

Also interested in documentation, if it’s available.

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 if you want to look for now. I’ll find that document and upload it here…

1 Like

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

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

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