Because before writing the code in the poi Workbook class has a close () method, after the 3.7 version will prompt can not find the way, is not new, but encountered some problems in the old way, this way to import the jar package are: poi - 3.17. Jar, poi - ooxml - 3.17. Jar, poi - ooxml - schemas - 3.12. Jar, xmlbeans - server. Jar

Before there is no import xmlbeans - server. This jar jar package, but in the process of running transactions

Java. Lang. NoClassDefFoundError: org/apache/xmlbeans/XmlOptions

Abnormalities, see everybody said the lack of xmlbeans the jar package, but the introduction of the jar package (import 07 version of excel, the old version will not) and will be prompted to

Org, the apache poi. POIXMLException: Java. Lang. Reflect. InvocationTargetException

Abnormalities, baidu watch everyone say jars conflict need to delete the xmlbeans jars, and then into an infinite loop, and hope to have the big help

CodePudding user response:

My project introduced

 
 
 Org. Apache. Poi 
 Poi - ooxml 
 3.14 & lt;/version> 
 

Rely on the following


This version of the workbook is a close () method of