JSP直接导出EXCEL表格
后台代码返回需要导出的jsp页面
在需要导出的jsp头部加上
<%@ page contentType="application/msexcel" %>
<%
out.clearBuffer();
response.setHeader("Content-Type","application/vnd.ms-excel;charset=UTF-8");
response.setHeader("Content-Disposition","attachment;filename=excel.xls");
%>