如何将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
