Java.io.eofexception: неожиданный конец входного потока Zlib с использованием Apache Poi ⇐ JAVA

[Anonymous]

Я пытаюсь создать таблицу Pivot Excel, используя Apache Poi.

На данный момент, когда я пытаюсь написать данные в рабочей книге. Неожиданный
end of zlib входной поток < /p>
< /blockquote>

Существует код класса: < /p>

public class PivotTable {

public static void createPivotTable(String pathToWorkbook, String sheetName) throws IOException {

Workbook workbook = new XSSFWorkbook(pathToWorkbook);

XSSFSheet sheet = (XSSFSheet) workbook.getSheet(sheetName);

int firstRowInd = sheet.getFirstRowNum();
int lastRowInd = sheet.getLastRowNum();
int firstCellInd = sheet.getRow(0).getFirstCellNum();
int lastCellInd = sheet.getRow(0).getLastCellNum() - 1;

//Specifying top left ant the bottom right of the table data
CellReference topLeft = new CellReference(firstRowInd, firstCellInd);
CellReference botRight = new CellReference(lastRowInd, lastCellInd);

//The area of data in table
AreaReference aref = new AreaReference(topLeft, botRight, SpreadsheetVersion.EXCEL2007);

//Position of the pivot table
CellReference pos = new CellReference(firstRowInd + 4, lastCellInd + 1);

//Creating the pivot table
XSSFPivotTable pivotTable = sheet.createPivotTable(aref, pos);

pivotTable.addRowLabel(0);
pivotTable.addRowLabel(2);
pivotTable.addColLabel(3);

FileOutputStream fileOut = new FileOutputStream(pathToWorkbook);
workbook.write(fileOut);
fileOut.close();

}
< /code>

И есть Stacktrace Exception: < /p>

Exception in thread "main" org.apache.poi.ooxml.POIXMLException: java.io.EOFException: Unexpected end of ZLIB input stream
at org.apache.poi.ooxml.POIXMLDocument.getProperties(POIXMLDocument.java:147)
at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:240)
at PivotTable.createPivotTable(PivotTable.java:50)
at Main.main(Main.java:14)
Caused by: java.io.EOFException: Unexpected end of ZLIB input stream
at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:240)
at org.apache.commons.compress.archivers.zip.InflaterInputStreamWithStatistics.fill(
InflaterInputStreamWithStatistics.java:52)
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158)
at org.apache.commons.compress.archivers.zip.InflaterInputStreamWithStatistics.read(
InflaterInputStreamWithStatistics.java:67)
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:122)
at org.apache.commons.compress.archivers.zip.InflaterInputStreamWithStatistics.read(
InflaterInputStreamWithStatistics.java:58)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.read(ZipArchiveThresholdInputStream.java:69)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager$RewindableInputStream.read(XMLEntityManager.java:2890)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(XMLEntityManager.java:674)
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(XMLVersionDetector.java:148)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:805)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3414)
at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1272)
at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1259)
at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
at org.openxmlformats.schemas.officeDocument.x2006.extendedProperties.PropertiesDocument$Factory.parse(Unknown Source)
at org.apache.poi.ooxml.POIXMLProperties.(POIXMLProperties.java:81)
at org.apache.poi.ooxml.POIXMLDocument.getProperties(POIXMLDocument.java:145)
... 3 more


Подробнее здесь: https://stackoverflow.com/questions/523 ... apache-poi