You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Nicholas DiPiazza <ni...@gmail.com> on 2025/09/17 14:11:09 UTC
Apache POI 5.x returning Broken pipe when writing excel document
I am trying to write an Excel document with Apache POI 5.x.
I have the following write code:
private void writeWorkbookToResponse(XSSFWorkbook outputWorkbook,
HttpServletResponse response) throws IOException {
try (OutputStream outputStream = response.getOutputStream();
BufferedOutputStream bos = new
BufferedOutputStream(outputStream)) {
outputWorkbook.write(bos);
bos.flush();
}
}
When attempting to save the document, I get the following exception thrown:
java.io.IOException: Broken pipe
at java.base/sun.nio.ch.FileDispatcherImpl.write0(Native Method)
at
java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:62)
at
java.base/sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:132)
at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:76)
at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:53)
at
java.base/sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:532)
at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:125)
at
org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1411)
at
org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:732)
at
org.apache.tomcat.util.net.SocketWrapperBase.flushBlocking(SocketWrapperBase.java:698)
at
org.apache.tomcat.util.net.SocketWrapperBase.flush(SocketWrapperBase.java:683)
at
org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.flush(Http11OutputBuffer.java:574)
at
org.apache.coyote.http11.filters.ChunkedOutputFilter.flush(ChunkedOutputFilter.java:156)
at
org.apache.coyote.http11.Http11OutputBuffer.flush(Http11OutputBuffer.java:216)
at
org.apache.coyote.http11.Http11Processor.flush(Http11Processor.java:1271)
at
org.apache.coyote.AbstractProcessor.action(AbstractProcessor.java:408)
at org.apache.coyote.Response.action(Response.java:208)
at
org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:300)
at
org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:266)
at
org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:133)
at
org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.flush(OnCommittedResponseWrapper.java:524)
at
java.base/java.io.BufferedOutputStream.flush(BufferedOutputStream.java:143)
at
org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream.flush(ZipArchiveOutputStream.java:974)
at
java.base/java.io.FilterOutputStream.flush(FilterOutputStream.java:153)
at
java.xml/com.sun.org.apache.xml.internal.serializer.WriterToUTF8Buffered.flush(WriterToUTF8Buffered.java:472)
at
java.xml/com.sun.org.apache.xml.internal.serializer.ToStream.flushWriter(ToStream.java:271)
at
java.xml/com.sun.org.apache.xml.internal.serializer.ToXMLStream.endDocument(ToXMLStream.java:227)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:137)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:96)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transformIdentity(TransformerImpl.java:718)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:780)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:395)
at
org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:79)
at
org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller.marshall(ZipPackagePropertiesMarshaller.java:53)
at
org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:575)
at
org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1487)
at
org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
I have tried to write the Excel document to a FileOutputStream instead of
to the servlet output stream, and it didn't seem to fix anything.
What might cause this behavior?
https://stackoverflow.com/questions/79767424/apache-poi-broken-pipe-when-calling-org-apache-poi-ooxml-poixmldocument-write
Re: Apache POI 5.x returning Broken pipe when writing excel document
Posted by PJ Fanning <fa...@apache.org>.
We've had similar issues reported in stackoverflow.com and elsewhere.
HTTP connections can be shut down if there is no activity for a while.
Generating a file with POI can be slow so the connection might be
closed while the file is still being generated.
I suggest using search tools or GenAI to track down answers on the
internet. POI has a DeferredGeneration sample that was submitted to us
by a user who said that the approach they championed helped with
reducing the delays where no bytes were being exchanged.
https://poi.apache.org/components/spreadsheet/examples.html (listed near bottom)
On Wed, 17 Sept 2025 at 16:29, Dominik Stadler
<do...@gmx.at.invalid> wrote:
>
> By "I have tried to write the Excel document to a FileOutputStream
> instead", do you mean simply writing the workbook to a file also caused the
> exception or rather writing to a file and then streaming out the
> file-content to the servlet-response did cause the issue?
>
> Overall it looks a lot like some issue with the Servlet-Response-Stream and
> less with Apache POI. Some "divide-and-conquer" could help, e.g. what if
> you simply stream out the same number of random bytes without using Apache
> POI?
>
> D.
>
>
> On Wed, Sep 17, 2025 at 4:11 PM Nicholas DiPiazza <
> nicholas.dipiazza@gmail.com> wrote:
>
> > I am trying to write an Excel document with Apache POI 5.x.
> >
> > I have the following write code:
> >
> > private void writeWorkbookToResponse(XSSFWorkbook outputWorkbook,
> > HttpServletResponse response) throws IOException {
> > try (OutputStream outputStream = response.getOutputStream();
> > BufferedOutputStream bos = new
> > BufferedOutputStream(outputStream)) {
> > outputWorkbook.write(bos);
> > bos.flush();
> > }
> > }
> >
> > When attempting to save the document, I get the following exception thrown:
> >
> > java.io.IOException: Broken pipe
> > at java.base/sun.nio.ch.FileDispatcherImpl.write0(Native Method)
> > at
> > java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:62)
> > at
> > java.base/sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:132)
> > at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:76)
> > at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:53)
> > at
> > java.base/sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:532)
> > at org.apache.tomcat.util.net
> > .NioChannel.write(NioChannel.java:125)
> > at
> > org.apache.tomcat.util.net
> > .NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1411)
> > at
> > org.apache.tomcat.util.net
> > .SocketWrapperBase.doWrite(SocketWrapperBase.java:732)
> > at
> > org.apache.tomcat.util.net
> > .SocketWrapperBase.flushBlocking(SocketWrapperBase.java:698)
> > at
> > org.apache.tomcat.util.net
> > .SocketWrapperBase.flush(SocketWrapperBase.java:683)
> > at
> >
> > org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.flush(Http11OutputBuffer.java:574)
> > at
> >
> > org.apache.coyote.http11.filters.ChunkedOutputFilter.flush(ChunkedOutputFilter.java:156)
> > at
> >
> > org.apache.coyote.http11.Http11OutputBuffer.flush(Http11OutputBuffer.java:216)
> > at
> > org.apache.coyote.http11.Http11Processor.flush(Http11Processor.java:1271)
> > at
> > org.apache.coyote.AbstractProcessor.action(AbstractProcessor.java:408)
> > at org.apache.coyote.Response.action(Response.java:208)
> > at
> > org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:300)
> > at
> > org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:266)
> > at
> >
> > org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:133)
> > at
> >
> > org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.flush(OnCommittedResponseWrapper.java:524)
> > at
> > java.base/java.io
> > .BufferedOutputStream.flush(BufferedOutputStream.java:143)
> > at
> >
> > org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream.flush(ZipArchiveOutputStream.java:974)
> > at
> > java.base/java.io.FilterOutputStream.flush(FilterOutputStream.java:153)
> > at
> >
> > java.xml/com.sun.org.apache.xml.internal.serializer.WriterToUTF8Buffered.flush(WriterToUTF8Buffered.java:472)
> > at
> >
> > java.xml/com.sun.org.apache.xml.internal.serializer.ToStream.flushWriter(ToStream.java:271)
> > at
> >
> > java.xml/com.sun.org.apache.xml.internal.serializer.ToXMLStream.endDocument(ToXMLStream.java:227)
> > at
> >
> > java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:137)
> > at
> >
> > java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:96)
> > at
> >
> > java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transformIdentity(TransformerImpl.java:718)
> > at
> >
> > java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:780)
> > at
> >
> > java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:395)
> > at
> >
> > org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:79)
> > at
> >
> > org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller.marshall(ZipPackagePropertiesMarshaller.java:53)
> > at
> > org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:575)
> > at
> > org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1487)
> > at
> > org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
> > I have tried to write the Excel document to a FileOutputStream instead of
> > to the servlet output stream, and it didn't seem to fix anything.
> >
> > What might cause this behavior?
> >
> >
> > https://stackoverflow.com/questions/79767424/apache-poi-broken-pipe-when-calling-org-apache-poi-ooxml-poixmldocument-write
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 5.x returning Broken pipe when writing excel document
Posted by Dominik Stadler <do...@gmx.at.INVALID>.
By "I have tried to write the Excel document to a FileOutputStream
instead", do you mean simply writing the workbook to a file also caused the
exception or rather writing to a file and then streaming out the
file-content to the servlet-response did cause the issue?
Overall it looks a lot like some issue with the Servlet-Response-Stream and
less with Apache POI. Some "divide-and-conquer" could help, e.g. what if
you simply stream out the same number of random bytes without using Apache
POI?
D.
On Wed, Sep 17, 2025 at 4:11 PM Nicholas DiPiazza <
nicholas.dipiazza@gmail.com> wrote:
> I am trying to write an Excel document with Apache POI 5.x.
>
> I have the following write code:
>
> private void writeWorkbookToResponse(XSSFWorkbook outputWorkbook,
> HttpServletResponse response) throws IOException {
> try (OutputStream outputStream = response.getOutputStream();
> BufferedOutputStream bos = new
> BufferedOutputStream(outputStream)) {
> outputWorkbook.write(bos);
> bos.flush();
> }
> }
>
> When attempting to save the document, I get the following exception thrown:
>
> java.io.IOException: Broken pipe
> at java.base/sun.nio.ch.FileDispatcherImpl.write0(Native Method)
> at
> java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:62)
> at
> java.base/sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:132)
> at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:76)
> at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:53)
> at
> java.base/sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:532)
> at org.apache.tomcat.util.net
> .NioChannel.write(NioChannel.java:125)
> at
> org.apache.tomcat.util.net
> .NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1411)
> at
> org.apache.tomcat.util.net
> .SocketWrapperBase.doWrite(SocketWrapperBase.java:732)
> at
> org.apache.tomcat.util.net
> .SocketWrapperBase.flushBlocking(SocketWrapperBase.java:698)
> at
> org.apache.tomcat.util.net
> .SocketWrapperBase.flush(SocketWrapperBase.java:683)
> at
>
> org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.flush(Http11OutputBuffer.java:574)
> at
>
> org.apache.coyote.http11.filters.ChunkedOutputFilter.flush(ChunkedOutputFilter.java:156)
> at
>
> org.apache.coyote.http11.Http11OutputBuffer.flush(Http11OutputBuffer.java:216)
> at
> org.apache.coyote.http11.Http11Processor.flush(Http11Processor.java:1271)
> at
> org.apache.coyote.AbstractProcessor.action(AbstractProcessor.java:408)
> at org.apache.coyote.Response.action(Response.java:208)
> at
> org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:300)
> at
> org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:266)
> at
>
> org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:133)
> at
>
> org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.flush(OnCommittedResponseWrapper.java:524)
> at
> java.base/java.io
> .BufferedOutputStream.flush(BufferedOutputStream.java:143)
> at
>
> org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream.flush(ZipArchiveOutputStream.java:974)
> at
> java.base/java.io.FilterOutputStream.flush(FilterOutputStream.java:153)
> at
>
> java.xml/com.sun.org.apache.xml.internal.serializer.WriterToUTF8Buffered.flush(WriterToUTF8Buffered.java:472)
> at
>
> java.xml/com.sun.org.apache.xml.internal.serializer.ToStream.flushWriter(ToStream.java:271)
> at
>
> java.xml/com.sun.org.apache.xml.internal.serializer.ToXMLStream.endDocument(ToXMLStream.java:227)
> at
>
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:137)
> at
>
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:96)
> at
>
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transformIdentity(TransformerImpl.java:718)
> at
>
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:780)
> at
>
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:395)
> at
>
> org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:79)
> at
>
> org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller.marshall(ZipPackagePropertiesMarshaller.java:53)
> at
> org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:575)
> at
> org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1487)
> at
> org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
> I have tried to write the Excel document to a FileOutputStream instead of
> to the servlet output stream, and it didn't seem to fix anything.
>
> What might cause this behavior?
>
>
> https://stackoverflow.com/questions/79767424/apache-poi-broken-pipe-when-calling-org-apache-poi-ooxml-poixmldocument-write
>