使用SXSSFWorkbook导出Excel

模板

	/** 导出表格SpringMVC */
	@RequestMapping(value = "/exportExcel")
	public String exportExcel(HttpServletResponse response, HttpServletRequest request)
			throws IOException {
   
		// 第一步，创建SXSSFWorkbook对象
		SXSSFWorkbook wb = new SXSSFWorkbook();
		List<Export> exportList = new ArrayList<Export>();
		// 列名
		String[] columnArr = {
    "身份证号" ,"姓名", "性别" };
		exportService.exportExcel(wb, exportList, columnArr);// exportList 为要导出的类的集合
		response.setContentType("APPLICATION/OCTET-STREAM");
		// 文件名
		String titleStr = "";
		titleStr = "导出模板";
		String title = new String(titleStr.getBytes("gb2312"