How to configure jython to use apachi poi

[idoitprone]

I am learning how to program with jython and I need to read excel files, but I am unable to get this package imported; apache-poi.noarch : The Java API for Microsoft Documents

I have all jython and apache-poi installed on my machine. It does not seem to work


I found this example on the web

#!/usr/bin/jython
""" read.py
Read an existant Excel file (Book1.xls) and show it on the screen
"""
from org.apache.poi.hssf.usermodel import *
from java.io import FileInputStream

file = "Book1.xls"
print file
fis = FileInputStream(file)
wb = HSSFWorkbook(fis)
sheet = wb.getSheetAt(0)

# get No. of rows
rows = sheet.getPhysicalNumberOfRows()
print wb, sheet, rows

cols = 0 # No. of columns
tmp = 0

# This trick ensures that we get the data properly even if it
# doesn't start from first few rows
for i in range(0, 10,1):
  row = sheet.getRow(i)
  if(row != None):
       tmp = sheet.getRow(i).getPhysicalNumberOfCells()
       if tmp > cols:
          cols = tmp
print cols

for r in range(0, rows, 1):
  row = sheet.getRow(r)
  print r
  if(row != None):
    for c in range(0, cols, 1):
        cell = row.getCell(c)
        if cell != None:
            print cell

#wb.close()
fis.close()

I get leep getting this error

Traceback (innermost last):
  File "./exceltest.py", line 5, in ?
ImportError: no module named poi

http://wiki.python.org/jython/PoiExample

I am using fedora 17

[marko]

The problem is that the apache-poi package you probably installed via yum:

yum install apache-poi

is implemented as Java jar files:

rpm -ql apache-poi

will show you those jars are under /usr/share/java/poi

but your jython script is only looking at python library paths for modules. One way to get that "poi.jar" in your script is to replace that "from org.apache.poi.hssf.usermodel import *" line with:

import sys
sys.path.append("/usr/share/java/poi/poi.jar")
from org.apache.poi.hssf.usermodel import *

I tried that here and it worked with Pycharm IDE. I suspect there's a better way to include jars in Pycharm but I didn't see it in the "edit configuration" tool.
Then to make sure that even the raw script was working I went to where I put my testpoi.py (copy and paste of your script with my couple lines of edits as shown above)
in my pycharm project:

cd ~/PycharmProjects/untitled2/
chmod +x testpoi.py
ls -l
-rw-rw-r--. 1 mos mos 6656 May 26 17:36 Book1.xls
-rwxrwxr-x. 1 mos mos 1005 May 26 17:26 testpoi.py*

(note Book1.xls is a simple two row spreadsheet I made for my test containing two rows with some numbers in them like this:
1 2 3
4 4 5
)

Then I just ran it is a raw command line script so it's not running from Pycharm:

./testpoi.py

Picked up _JAVA_OPTIONS: -Dswing.aatext=true -Dawt.useSystemAAFontSettings=on -Dswing.defaultlaf=com.sun.java.swing.plaf.gtk.GTKL ookAndFeel
Book1.xls
org.apache.poi.hssf.usermodel.HSSFWorkbook@5be7ef2 c org.apache.poi.hssf.usermodel.HSSFSheet@580760d7 2
3
0
1.0
2.0
3.0
1
4.0
4.0
5.0

So that works too.

PS. another thing to watch for, I was just trying jython support in Fedora 16 and found that because the jython package in Fedora is very
old and behind the current version (Fedora 16 has version 2.2.1 while the latest stable jython is 2.5.2), some things you're accustomed to using
in normal python 2.7 (like the "with open() as file:" context statement (see: http://effbot.org/pyref/with.htm ) won't work.


Mark

[idoitprone]

thnks. It doesnt really matter which python version to me because I am just using it to call some java apis