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!