struts2 jxl简易使用

public String exportExcel() throws Exception {
		HttpServletRequest request=ServletActionContext.getRequest();
		HttpServletResponse response=ServletActionContext.getResponse();
		response.setCharacterEncoding("UTF-8");
		response.setContentType("file");
		try {
			response.setHeader("Content-Disposition", "inline; filename="+ new String("使用EXCEL.xls".getBytes("GB2312"), "iso8859-1"));
		} catch (UnsupportedEncodingException e1) {
			e1.printStackTrace();
		}
		// 这个地方一定要进行编码的转换要不然中文字符会出现乱码.
		// 设置下载头信息.end,
		OutputStream output = null;
		InputStream fis = null;
		try {
			output = response.getOutputStream();
			jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(output);
			jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true);
		    jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
		    wcfF.setWrap(true);//自动换行
		    wcfF.setAlignment(jxl.format.Alignment.CENTRE);//把水平对齐方式指定为居中 
		    wcfF.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
			jxl.write.WritableSheet sheet = wwb.createSheet("使用EXCEL", 0);
			 
			CellView cv = new CellView(); //定义一个列显示样式 
		    cv.setFormat(wcfF);//把定义的单元格格式初始化进去
		    cv.setSize(30*200);//设置列宽度（不设置的话是0，不会显示）
			sheet.mergeCells(0,0,4,0); //合并单元格
			sheet.setColumnView(0, cv);//设置工作表中第n列的样式
			sheet.addCell(new Label(0, 0, "使用EXCEL",wcfF));
			NumberFormat dp3 = new NumberFormat("###,###"); //设置单元格里面的数字格式
		    WritableCellFormat dp3cell = new WritableCellFormat(dp3);
		    dp3cell.setWrap(true);
		    Number number = new Number(1,1,1,dp3cell);
			sheet.addCell(number);
			number = new Number(1,2,1,dp3cell);
			sheet.addCell(number);
			Formula f = new Formula(1, 3,  "SUM(B2:B3)", dp3cell); //设置C10公式
 			sheet.addCell(f);
			wwb.write();
			wwb.close();
		} catch (Exception e) {
			System.out.println("Error!");
			e.printStackTrace();
		} finally {// 正常关闭输入输出流.
			try {
				if (fis != null) {
					fis.close();
					fis = null;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				if (output != null) {
					output.close();
					output = null;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return null;
	}