Java导入导出功能

@AutoLog(value = "Excel导出")
	@ApiOperation(value = "Excel导出", notes = "Excel导出")
	@GetMapping(value = "/export")
	public void export(HttpServletResponse response) {

		List<StudentInformation> stuList = new ArrayList<StudentInformation>();
		stuList.add(new StudentInformation("张三", new Date()));
		stuList.add(new StudentInformation("李四", new Date()));
		stuList.add(new StudentInformation("王五", new Date()));
		stuList.add(new StudentInformation("刘黑", new Date()));
		stuList.add(new StudentInformation("许飞", new Date()));
		stuList.add(new StudentInformation("谢帅", new Date()));

		// 通过工具类创建writer，默认创建xls格式
		ExcelWriter writer = ExcelUtil.getBigWriter();
		// 自定义标题名
		writer.addHeaderAlias("name", "姓名");
		writer.addHeaderAlias("birthDay", "生日");
		// 合并单元格后的标题行，使用默认标题样式
		writer.merge(2, "学生人员信息");
		// 一次性写出内容，使用默认样式，强制输出标题
		writer.write(stuList, true);

		// out为OutputStream,简要写出到目标流
		// response为HttpServletRespone对象
		response.setContentType("application/vnd.ms-excel;charset=utf-8");
		// test.xls是弹出下载对话框的文件名，不能为中文，中文请自行编码
		// String name = StringUtils.toUtf8String("申请信息");
		String name = "学生信息";
		response.setHeader("Content-Disposotion", "attachment;filename=" + name + ".xls");
		ServletOutputStream out = null;
		try {
			out = response.getOutputStream();
			writer.flush(out, true);

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			writer.close();
		}
		// 此处关闭输出servlet流
		IoUtil.close(out);
	}