如何将Excel导出时使用accessExternalStylesheet功能?

摘要:通过Hutool+Poi导出Excel出现异常错误:java.lang.IllegalArgumentException: 不支持:http:javax.xml.XMLConstantspropertyaccess
通过Hutool+Poi导出Excel出现异常错误:java.lang.IllegalArgumentException: 不支持: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) ~[xalan-2.7.2.jar:na] at org.apache.poi.util.XMLHelper.trySet(XMLHelper.java:283) [poi-5.2.2.jar:5.2.2] at org.apache.poi.util.XMLHelper.getTransformerFactory(XMLHelper.java:224) [poi-5.2.2.jar:5.2.2] at org.apache.poi.util.XMLHelper.newTransformer(XMLHelper.java:230) [poi-5.2.2.jar:5.2.2] at org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:56) [poi-ooxml-5.2.2.jar:5.2.2] at org.apache.poi.openxml4j.opc.internal.ZipContentTypeManager.saveImpl(ZipContentTypeManager.java:68) [poi-ooxml-5.2.2.jar:5.2.2] at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.save(ContentTypeManager.java:450) [poi-ooxml-5.2.2.jar:5.2.2] at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:563) [poi-ooxml-5.2.2.jar:5.2.2] at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1490) [poi-ooxml-5.2.2.jar:5.2.2] at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227) [poi-ooxml-5.2.2.jar:5.2.2] at cn.hutool.poi.excel.ExcelWriter.flush(ExcelWriter.java:1301) [hutool-all-5.8.18.jar:5.8.18] 问题源代码 @SpringBootTest public class AppTest { @Autowired private JdbcTemplate jdbcTemplate; @Test public void test() throws IOException { String sql = "SELECT t.user_id AS userId,t.module_id AS moduleId, t3.module_name AS modulename, " + "t.exam_id AS examId,t.exam_score AS examScore,t1.exam_name AS examName,t2.ygxm AS ygxm, t.exam_stime AS examsTime " + "FROM user_exam t " + "LEFT JOIN exam_information t1 ON (t1.exam_id = t.exam_id) " + "LEFT JOIN trainee t2 ON (t2.ygbh = t.user_id) " + "LEFT JOIN
阅读全文