https://bz.apache.org/bugzilla/show_bug.cgi?id=58747
Bug ID: 58747
Summary: NullPointerException parsing XLSX files generated by
openpyxl library
Product: POI
Version: 3.13-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: sergio.na...@gmail.com
Created attachment 33356
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33356&action=edit
incriminated XLSX file
Stacktrace:
java.lang.NullPointerException
at
org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator.<init>(XSSFReader.java:202)
at
org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator.<init>(XSSFReader.java:170)
at
org.apache.poi.xssf.eventusermodel.XSSFReader.getSheetsData(XSSFReader.java:164)
at
org.apache.poi.xssf.eventusermodel.XSSFReader$getSheetsData$0.call(Unknown
Source)
Triggered by getSheetsData() in this code (Groovy):
def container = OPCPackage.open(file)
ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(container)
XSSFReader reader = new XSSFReader(container)
StylesTable styles = reader.getStylesTable()
XSSFReader.SheetIterator iter = (XSSFReader.SheetIterator)
reader.getSheetsData()
Curious thing is: invoking getStylesTable() *after* getSheetsData() like this
below does not trigger the NPE:
def container = OPCPackage.open(file)
ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(container)
XSSFReader reader = new XSSFReader(container)
XSSFReader.SheetIterator iter = (XSSFReader.SheetIterator)
reader.getSheetsData()
StylesTable styles = reader.getStylesTable()
Example XLSX file is attached
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
