# Load XLS usnig Apache Poi

**URL:** <https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146>\
**Category:** Ignition\
**Tags:** ignition79, scripting\
**Created:** [April 26, 2017, 3:09pm UTC](https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146 "2017-04-26T15:09:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Juank\_Chavarria](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@Juank\_Chavarria](https://forum.inductiveautomation.com/u/Juank_Chavarria)\
**Post date:** [April 26, 2017, 3:09pm UTC](https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146/1 "2017-04-26T15:09:23Z")

</div>

Hi! Have a problem using the Jar POI. When import \*\*from org.apache.poi.hssf.usermodel import \* \*\* in some cases it works, and others do not. For example, I’m working on the designer and all ok, but trying to run the script on the client shows me the following:

**ImportError: No module named poi**

After this happens, I close the designer and re-open it and the same error occurs.

I noticed that in the folder:

C:\Program Files\Inductive Automation\Ignition\lib\core\gateway (And in other folders from \lib\core)

is in the file poi-3.14.jar

Do you have any idea what is happening or how to solve this?

PD: What I need is to load an exel file.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [April 26, 2017, 3:29pm UTC](https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146/2 "2017-04-26T15:29:13Z")

</div>

It should work if you import the classes you need directly. Here is an example:

```auto
from org.apache.poi.xssf.usermodel import XSSFWorkbook

```

Also, this tutorial on Apache POI in Ignition might be helpful: [http://blog.perfectabstractions.com/2017/04/05/using-the-pa-office-document-module/](http://blog.perfectabstractions.com/2017/04/05/using-the-pa-office-document-module/)

That blog post shows an example of loading an Excel file into an Ignition Power Table.

---

<div class="post-metadata">

**Author:** ![Juank\_Chavarria](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@Juank\_Chavarria](https://forum.inductiveautomation.com/u/Juank_Chavarria)\
**Post date:** [April 26, 2017, 4:41pm UTC](https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146/3 "2017-04-26T16:41:49Z")

</div>

Now receive this error

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/03601de71963737c71b9b823ef456433210ac857.png)

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [April 26, 2017, 4:49pm UTC](https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146/4 "2017-04-26T16:49:30Z")

</div>

Try downloading and installing the PA Office Document Module to see if it works with that. You can download it here: [http://www.perfectabstractions.com/products.html](http://www.perfectabstractions.com/products.html)

---

<div class="post-metadata">

**Author:** ![Juank\_Chavarria](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@Juank\_Chavarria](https://forum.inductiveautomation.com/u/Juank_Chavarria)\
**Post date:** [April 26, 2017, 5:34pm UTC](https://forum.inductiveautomation.com/t/load-xls-usnig-apache-poi/14146/5 "2017-04-26T17:34:53Z")

</div>

Is there any free way to do it? Even with python?