Excel View 4 Spring

Excel View 4 Spring

@RequestMapping(value = "/exportQualifiedPersonList", method = RequestMethod.GET)
public ModelAndView exportQualifiedPersonList(
Model model,
HttpServletRequest request,
HttpServletResponse response,
CertificateInternalQueryDto inputDto) throws JSONException, IOException {

inputDto.setPage(1);

inputDto.setRp(SysConstants.EXCEL_MAX_LINE_NUM - 1);

String fileName = "XXX";

List<KeyValuePair> kvList = new ArrayList<KeyValuePair>();
kvList.add(new KeyValuePair("姓名", "XM"));
kvList.add(new KeyValuePair("证件号码", "ZJH"));

GridDataDto<XXXDto> gdd = this.XXXManager.findXXX(inputDto);

ExcelView4Common<XXXDto> excelView = new ExcelView4Common<XXXDto>(fileName, kvList, gdd.getRows());

return new ModelAndView(excelView);
}