How to parse excel spreadsheet from scriptrunner

[OToole]

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.

https://github.com/dtanner/groovy-excel-reader/blob/master/ExcelReader.groovy

https://gist.github.com/jkeam/4083570

http://www.technipelago.se/blog/show/groovy-poi-excel

https://community.atlassian.com/t5/Answers-Developer-Questions/Script-Reading-XLSX-File-from-Server/qaq-p/562934

But I am having trouble just loading the libraries,  

I  tried using  grape to get this to resolve.

//@Grab('org.apache.poi:poi:4.0')
//@Grab('org.apache.poi:poi-ooxml:4.0')
/*import groovy.grape.Grape
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')
*/

@Grapes([
@Grab(group='org.apache.poi', module='poi', version='4.0'),
@Grab(group='org.apache.poi', module='poi-ooxml', version='4.0')
])


import org.apache.poi.ss.usermodel.*
import org.apache.poi.hssf.usermodel.*
import org.apache.poi.sssf.usermodel.*
import org.apache.poi.ss.util.*  

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.

https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Workbook.html

I am running the above script from the Jira->Add ons->Script Console

Scriptrunner is 5.5.2

Jira 7.5.2

Any Ideas??

Thanks

[ABRAR ALI]

Hi @OToole ,

Did you find a way to do this ?

-Abrar

[Vikrant Yadav]

Hi @OToole  Kindly check below post for reading CSV file in Script Runner :- 

https://community.atlassian.com/t5/Adaptavist-discussions/How-to-read-csv-file-in-script-runner/td-p/1701649

Thanks