Hi All, I am trying to pull data from an excel spreadsheet. I have found several excel parsers for groovy that are based on apache poi which seem like what I need.
But I am having trouble just loading the libraries,
I tried using grape to get this to resolve.
groovy.grape.Grape.grab(group:'org.apache.poi', module:'poi', version:'4.0')
groovy.grape.Grape.grab(group:'org.apache.poi', module:'poi-ooxml', version:'4.0')
@Grab(group='org.apache.poi', module='poi', version='4.0'),
@Grab(group='org.apache.poi', module='poi-ooxml', version='4.0')
InputStream inp = new FileInputStream("C:\\temp\\testFile.xlsx")
Workbook wb = WorkbookFactory.create(inp);
Error grabbing Grapes -- [unresolved dependency: org.apache.poi#poi-ooxml;4.0: not found,unresolved dependency: org.apache.poi#poi;4.0: not found] j
Failed, on all saying that org.apache.poi was unresolved.
So I have downloaded the apache.poi jar files version 4.0 and placed the 6 jar files into web-inf/lib folder
Now I removed the grapes code and ran it and I get no errors on the import lines but it says it cannot resolve Workbook. (Even if I scope it to org.apache.poi.ss.usermodel.Workbook)
I tried doing import org.apache.poi.ss.usermodel.Workbook and that does fail.
But the documentation for java says that is where it is located.
I am running the above script from the Jira->Add ons->Script Console
Scriptrunner is 5.5.2