直接上代码:
先准备模板文件:
Controller:
/**
* 下载批量发送短信的模板
* @param response
*/
@CrossOrigin
@PostMapping(value = "/batch_sms_send/downloadSmsTemplate", produces = {"application/json;charset=UTF-8"})
public void downloadSmsTemplate(HttpServletResponse response) {
byte[] fileSource = ProjectConfiguration.fileBytes;
//防止对原数据进行操作
byte[] fileBytes = Arrays.copyOf(fileSource, fileSource.length);
//下载模板
try {
Workbook wb = WorkbookFactory.create(new ByteArrayInputStream(fileBytes));
List<String> titleList = new ArrayList();
// titleList.add("标头1");
ExcelUtil.export(wb, ProjectConfiguration.fileName, titleList, response);
} catch (Exception e) {
logger.info("下载模板出现问题");
e.