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. 
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…
@cody.tamaki thanks for sharing this code. You could upload it to https://github.com/IgnitionModuleDevelopmentCommunity !