java后台生成Excel并下载

java生成Excel并下载（业务需求:前台点击导出按钮，后台生成Excel并下载）

导入所需要的jar包

<dependency>
	<groupId>net.sourceforge.jexcelapi</groupId>
	<artifactId>jxl</artifactId>
	<version>2.6.12</version>
</dependency>

编写所需要的类

		ServletRequestAttributes requestAttributes =
		(ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
		HttpServletResponse response = requestAttributes.getResponse();
		HttpServletRequest request = requestAttributes.getRequest();

		// 文件名
		String filename = "房间列表.xls";

		try {
   

			// 写到服务器上
			String path = request.getSession().getServletContext().getRealPath("") + "/" + filename;

			// 写到服务器上（这种测试过，在本地可以，放到linux服务器就不行）
			//String path =  this.getClass().getClassLoader().getResource("").getPath()+"/"+filename;

			File name = new File(path);
			// 创建写工作簿对象
			WritableWorkbook workbook = Workbook.createWorkbook(name);
			// 工作表
			WritableSheet sheet = workbook.createSheet("房间列表", 0);
			// 设置字体;
			WritableFont font = new WritableFont(WritableFont.ARIAL,
			14, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);

			WritableCellFormat cellFormat =