文章目录
1、导入依赖
cn.hutool
hutool-all
5.7.20
org.apache.poi
poi-ooxml
4.1.2
2、代码
import java.net.URLDecoder;
import org.apache.commons.io.IOUtils;
@Override
public void downLoadPropertyExcel(HttpServletRequest request,HttpServletResponse response) throws Exception {
String fileName = "房源信息导入模板.xlsx";
fileName = URLDecoder.decode(fileName, "UTF-8");
InputStream in = this.getClass().getResourceAsStream("/template/房源信息导入模板.xlsx");
String filenamedisplay = URLEncoder.encode(fileName, "UTF-8");
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("UTF-8");
response.setHeader("Content-Disposition", "attachment; filename=" + filenamedisplay);
response.setContentType("application/x-download;charset=utf-8");
OutputStream out = response.getOutputStream();
IOUtils.copy(in, out);
out.flush();
in.close();
}
3、前端测试
点击下载文件