Java-poi导出Excel文件名有中文,ie浏览器测试中的小插曲
问题描述
Java-poi导出Excel文件名有中文,ie浏览器本地测试时,控制台错误信息:
信息: Error parsing HTTP request header
Note: further occurrences of HTTP header parsing errors will be logged at DEBUG level.
java.lang.IllegalArgumentException: Invalid character found in the request target. The valid characters are defined in RFC 7230 and RFC 3986
at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:476)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:687)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
寻找解决方法
1、maxHttpHeaderSize
求助强大的网络,在网上搜解决办法。
直接搜错误信息Error parsing HTTP request header Note: further occurrences of HTTP header parsing errors will be logged at DEBUG level.
好多都是说改tomcat的配置文件server.xml
在<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000" redirectPort="8443" maxHttpHeaderSize="你想要的大小" />的配置中增加maxHttpHeaderSize的配置
然而并没有什么用
2、编码问题
搜错误信息Invalid character found in the request target. The valid characters are defined in RFC 7230 and RFC 3986
发现可能是编码的问题,
127.0.0.1:8080/Horse/export/exportExcel?ExcelName=马品种常量表(报错400)
127.0.0.1:8080/Horse/export/exportExcel?ExcelName=%E9%A9%AC%E5%93%81%E7%A7%8D%E5%B8%B8%E9%87%8F%E8%A1%A8(可正常使用)
解决问题
fileName = URLEncoder.encode(fileName, "UTF-8");
response.setHeader("Content-disposition", "attachment;filename="+fileName);
ie浏览器没问题,其他某些浏览器文件名是乱码,最终解决方案见这里