1、第一步Controller
String[] columnArr = {"姓名", "学号", "手机号"};
//导出题目Excel创建HSSFWorkbook
XSSFWorkbook wb = userBaseInfoService.createTemplateHSSFWorkbook(columnArr);
// 第三步,将文件存到指定位置
response.setContentType("APPLICATION/OCTET-STREAM");
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
String titleStr = "模板" + dateFormat.format(new Date());
String title = new String(titleStr.getBytes("gb2312"),"iso-8859-1");
response.setHeader( "Content-Disposition" ,"attachment;filename=\"" + title + ".xlsx" + "\"" );
OutputStream ouputStream = response.getOutputStream();
wb.write(ouputStream);
ouputStream.flush();
ouputStream.close();
return null;片
2、第二步Service
public XSSFWorkbook createT