WEB批量导出EXCEL太慢
excel批量导出太慢,可以使用[csv][6]的方式导出:
代码块
设置响应头,例如:
response.reset(); //清空输出流
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-disposition","attachment; filename=加息记录列表"+currentTime+".csv"); // 设定输出文件头
response.setContentType("application/csv"); // 定义输出类型
代码块
工具类,例如:
“` JAVA
public class CsvWriter extends BufferedWriter {
/**
* set wirter
*
* @param out writer
*/
public CsvWriter(final Writer out) {
super(out);
}
/**
* csv Write line
*
* @param csvLine
* csv line
* @throws IOException IOException
*/
public void writeLine(final List<String> csvLine) throws IOException {
StringBuffer sb = new StringBuffer();
for (int i = 0; i < csvLine.size(); i++) {
String line = csvLine.get(i);
if (line == null) {
line = "";
}
sb.append("\"").append(line.replaceAll("\"", "\"\"")).append("\",");
}
super.write(sb.deleteCharAt(sb.length() - 1).toString());
super.newLine();
}
}
经验:1,如果中文返回出现??字符,这表明没有加response.setCharacterEncoding(“UTF-8”);这句话。
2,如果返回的中文是“宸茶繃鏈”这种乱码,说明浏览器的解析问题,应该检查下是否忘加response.setHeader(“Content-type”, “text/html;charset=UTF-8”);这句话。