使用POI处理Excel时，遇到EOFException异常，ZLIB压缩流输入结束异常，该如何解决？

本文共计160个文字，预计阅读时间需要1分钟。

错误写法：Workbook workbook=null; try { // 会报错 File file=new File(D:\\\\1.xlsx); workbook=new XSSFWorkbook(file); ByteArrayOutputStream baos=new ByteArrayOutputStream(); workbook.write(baos); workbook.close(); bytes=baos.toBy

改正后：Workbook workbook=null; try { File file=new File(D:\\1.xlsx); workbook=new XSSFWorkbook(file); ByteArrayOutputStream baos=new ByteArrayOutputStream(); workbook.write(baos); workbook.close(); byte[] bytes=baos.toByteArray(); }

错误写法

Workbook workbook = null; try { // 会报错 File file = new File("D:\\1.xlsx"); workbook = new XSSFWorkbook(file); ByteArrayOutputStream baos = new ByteArrayOutputStream(); workbook.write(baos); workbook.close(); bytes = baos.toByteArray(); } catch (Exception e) { e.printStackTrace(); }

正确写法

Workbook workbook = null; try { File file = new File("D:\\1.xlsx"); workbook = new XSSFWorkbook(new FileInputStream(file)); ByteArrayOutputStream baos = new ByteArrayOutputStream(); workbook.write(baos); workbook.close(); bytes = baos.toByteArray(); } catch (Exception e) { e.printStackTrace(); }