Read xlsx file without paid modules

Hi everyone!

Up to now and at the current version of Ignition, what is a good/easy way to read a xlsx file without using 3rd party paid modules if possible?

Thanks a bunch!

Do you mean Good or Easy? Because good is possible, but not really easy. By that, I mean you can create your own add-on module that includes the Apache POI jars, for free. You’ll probably spend more (time==money) figuring out how to do that than it costs just to buy Kymera’s module.

1 Like

There are several open source Python libraries you could potentially use. Just google “python open source xlsx reader”

I’ve had luck with xlrd in the past: https://pypi.org/project/xlrd/

If you are using Ignition 7.9 you have to go get an older version of xlrd… I think 0.7.9. I’ve not testing it with Ignition 8.x to see if you can use a newer version.

Thanks for your response pturmel. I am familiar with the module but I took a look on its documentation and what I found is that the module exports to Excel formats not read from it. Check it out.
Capture

1 Like

Thanks bschroeder. I found that xlrd is for .xls files only but there are other libraries like openpyxl that works for xlsx. I am just getting errors when trying to use it. I made sure that the library version is compatible with Python 2.7 but no luck so far.

The Kymera module only exposes convenience functions for exporting, true, but it loads the Apache POI jars, which you can use directly in jython. You should contact their support for suggestions.

Apache POI is also included by Ignition already, though the Kymera modules may include some additional POI-related jars?

2 Likes

Kevin , do you have some manual introduce use ignition’s Apache POI to read and import the Excel document? thanks a lot.

1 Like

This is a bit dated but should get you started:

https://www.tutorialspoint.com/apache_poi/index.htm

The formal documentation for the current version in v8 is here:

http://poi.apache.org/apidocs/4.1/