使用POI时遇到EOFException错误，如何处理ZLIB输入流异常结束问题？

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

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

修改后：尝试读取Excel文件并写入字节流，但存在错误：

javaWorkbook 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();} catch (Exception e) { e.printStackTrace();}

错误写法

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(); }