Read an excel file from post function using script runner

OToole November 9, 2018

I am trying to read an .xlsx file from a post function using script runner.  

Is this even possible?  Do I need to create a plugin to do this?

 

I know I need to import the apache poi libraries.   I have added the poi version 4.0 to my web-inf/lib folder and restarted 

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

Workbook wb = new XSSFWorkbook();

Running from the script console,  Jira 7.12.3, Scriptrunner 5.4.39

First run I get the error:

Provider for class javax.xml.stream.XMLEventFactory cannot be created

After that the error is

Could not initialize class org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller

I don't want to continue to try and solve this if it is not even something that is possible from the script runner.  

Thanks!

 

0 answers

Suggest an answer

Log in or Sign up to answer