目录
发生场景:
在springboot2.6.4项目下,使用HuTool5.7.22的ExcelWriter生成Excel文件的时候,关闭writer的时候报此错误,但是不影响代码执行结果,因为是在Main方法中做的业务逻辑处理;
11:48:23.441 [main] WARN org.apache.poi.util.XMLHelper - SAX Feature unsupported [log suppressed for 5 minutes] http://javax.xml.XMLConstants/property/accessExternalStylesheet
java.lang.IllegalArgumentException: 不支持:http://javax.xml.XMLConstants/property/accessExternalStylesheet
at org.apache.xalan.processor.TransformerFactoryImpl.setAttribute(TransformerFactoryImpl.java:571)
at org.apache.poi.util.XMLHelper.trySet(XMLHelper.java:283)
at org.apache.poi.util.XMLHelper.getTransformerFactory(XMLHelper.java:224)
at org.apache.poi.util.XMLHelper.newTransformer(XMLHelper.java:230)
at org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:56)
发生原因:
xalan.jar指定的TransformerFactory实现类在META-INF/services/javax.xml.transform.TransformerFactory文件内(如下图)不支持这么玩,不支持javax.xml.XMLConstants/property/accessExternalStylesheet被setAttribute;
解决办法:
覆盖掉这个实现类即可,在项目resources目录下新建META-INF/services/javax.xml.transform.TransformerFactory文件,然后将新的实现类拷贝进去就OK
com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl
#com.sun.org.apache.xalan.internal.xsltc.TransformerFactoryImpl
PS:根据实际情况切换一下实现类,很有可能Not Found.