java 导出excel打开报错_java在导出excel报表的过程中报错: Socket closed

并不是每一场导出excel都报错,只是偶尔。然后导出的excel表无法打开,也无法修复。

/**生成报表*/

String filename = "报表"+TimeUtil.getCurrentTime()+".xls";

try {

filename = new String(filename.getBytes("GBK"), "ISO-8859-1");

} catch (UnsupportedEncodingException e) {

logger.error("下载报表无效字符集");

}

response.addHeader("Content-Disposition", "attachment;filename="+filename);

response.setContentType("application/octet-stream");

OutputStream outputStream = null;

try {

outputStream = response.getOutputStream();

wb.write(outputStream);//------报错行--

outputStream.flush();

outputStream.close();

} catch (IOException e) {

logger.error("下载报表异常:",e);

}finally{

try {

if(outputStream!=null){

outputStream.close();

}

} catch (IOException e) {

logger.error("下载报表流关闭异常");

}

}

下面是报错信息:

java.net.SocketException: Socket closed

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:568)

at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:539)

at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:427)

at weblogic.servlet.internal.CharsetChunkOutput.flush(CharsetChunkOutput.java:298)

at weblogic.servlet.internal.ChunkOutput$2.checkForFlush(ChunkOutput.java:648)

at weblogic.servlet.internal.CharsetChunkOutput.write(CharsetChunkOutput.java:200)

at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:148)

at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:148)

at java.io.OutputStream.write(OutputStream.java:58)

at org.apache.poi.poifs.storage.BigBlock.doWriteData(BigBlock.java:67)

at org.apache.poi.poifs.storage.DocumentBlock.writeData(DocumentBlock.java:195)

at org.apache.poi.poifs.storage.BigBlock.writeBlocks(BigBlock.java:98)

at org.apache.poi.poifs.storage.DocumentBlock.writeBlocks(DocumentBlock.java:34)

at org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore.writeBlocks(POIFSDocument.java:547)

at org.apache.poi.poifs.filesystem.POIFSDocument.writeBlocks(POIFSDocument.java:303)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.writeFilesystem(POIFSFileSystem.java:385)

at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1232)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值