1、将模板放到服务器的目录里(随便哪个目录均可,自定义)
模板一般只定义Title
2、Controller
@RequestMapping(value = "/exportBlackCat", method = RequestMethod.POST, produces = "application/json; charset=utf-8")
@ApiOperation(httpMethod = "POST", value = "导出申报资料")
public void exportBlackCat(@Valid @ApiParam @RequestBody ExportBlackCatIn exportBlackCatIn, HttpServletRequest request, HttpServletResponse response) {
XSSFWorkbook workbook = null;
OutputStream out = null;
InputStream ips = null;
try {
// 从数据库中查出对应数据
List
3、向模板中插入数据(数据库查询出来的数据)
public static void xssfBlackCatData(List