天天看點

EASYPOI導入報錯The part /xl/drawings/drawing1.xml failed to be saved

EASYPOI導入報錯The part /xl/drawings/drawing1.xml failed to be saved

Caused by: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : The part /xl/drawings/drawing1.xml failed to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@73a09dd0
	at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:552)
	at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1489)
	at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1472)
	at org.apache.poi.openxml4j.opc.ZipPackage.closeImpl(ZipPackage.java:428)
	at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:449)
	at com.alibaba.excel.analysis.ExcelAnalyserImpl.finish(ExcelAnalyserImpl.java:122)
	... 124 common frames omitted
Caused by: org.apache.poi.openxml4j.exceptions.OpenXML4JException: The part /xl/drawings/drawing1.xml failed to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@73a09dd0
	at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:541)
... 129 common frames omitted
           
EASYPOI導入報錯The part /xl/drawings/drawing1.xml failed to be saved

看着沒有任何問題,首先看報錯:

The part /xl/drawings/drawing1.xml failed to be saved
           

經查是由于excel上面有圖檔導緻報錯。

于是排查,發現上面沒有圖檔,可能是文本框,于是通過将excel上隐藏的文本框展示了出來,發現:

EASYPOI導入報錯The part /xl/drawings/drawing1.xml failed to be saved

将文本框全部删除,導入成功。

總結:碰到這個報錯,看看有沒有隐藏的圖檔或者文本框,說不定能夠解決這個問題。

EXCEL檢視隐藏的文本框的方式:

https://jingyan.baidu.com/article/fa4125acd024e328ac70921c.html