from org.apache.poi.hssf.usermodel import *
I am getting import no module named hssf.
I am trying to parse an excel file found on the same directory as plugin.
https://wiki.python.org/jython/PoiExample
For time being its just testing, I will use excel file later. However my first problem how can I solve the import error?
file = “test.xlsx”
fis = FileInputStream(file)
wb = HSSFWorkbook(fis)
sheet = wb.getSheetAt(0)
rows = sheet.getPhysicalNumberOfRows()cols = 0 # No. of columns tmp = 0 for i in range(0, 10,1): row = sheet.getRow(i) if(row != None): tmp = sheet.getRow(i).getPhysicalNumberOfCells() if tmp > cols: cols = tmp message2 = IngestMessage.createMessage(IngestMessage.MessageType.DATA,"wb: ", wb) PostBoard.postMessage(message2) message3 = IngestMessage.createMessage(IngestMessage.MessageType.DATA,"row: ", rows) PostBoard.postMessage(message3) message4 = IngestMessage.createMessage(IngestMessage.MessageType.DATA,"cols: ", cols) PostBoard.postMessage(message4) for r in range(0, rows, 1): row = sheet.getRow(r) messag = IngestMessage.createMessage(IngestMessage.MessageType.DATA,"r: ", ""+r) PostBoard.postMessage(messag) if(row != None): for c in range(0, cols, 1): cell = row.getCell(c) if cell != None: messag1 = IngestMessage.createMessage(IngestMessage.MessageType.DATA,"cell: ", ""+cell) PostBoard.postMessage(messag1) fis.close()