社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
背景介绍
实现方式
ResourceLoader loader = new DefaultResourceLoader();
Resource resource = loader
.getResource("classpath:META-INF/resources/zjlh-cmcs-ui/importtemplates");
分享SpringBoot获取Excel模板的工具类,配合上面的方式下载模板
@Controller
@RequestMapping(value = "templates")
public class TemplatesDownloadController extends BaseController {
@RequestMapping("import/download")
public void downloadExcel(HttpServletResponse rsp, HttpServletRequest req, String directory,
String fileName) throws Exception {
rsp.setContentType("application/vnd.ms-excel;charset=utf-8");
rsp.setHeader("Content-Disposition",
"attachment;fileName=" + URLEncoder.encode(fileName, "UTF-8"));
ResourceLoader loader = new DefaultResourceLoader();
Resource resource = loader.getResource(
WebConstant.TEMPLATE_REAL_PATH + File.separator + directory + File.separator + fileName);
try (InputStream in = resource.getInputStream(); //
OutputStream out = rsp.getOutputStream()) {
StreamUtils.copy(in, out);
}
}
}
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!