做下载xls模板操作

protected ModelAndView handleRequestInternal(HttpServletRequest request,
HttpServletResponse response) throws Exception {

response.setContentType("application/octet-stream");
response.setHeader("Content-Disposition","attachment; filename=" + java.net.URLEncoder.encode("团队目标上传模板.xls","UTF-8"));
WritableWorkbook book = Workbook.createWorkbook(response.getOutputStream());
// sheet
WritableSheet sheet = book.createSheet("团队目标设置上传模板", 0);
// 内容项
// 行头label
WritableFont labelfont = new WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.BOLD);
WritableCellFormat labelformat = new WritableCellFormat(labelfont);
//文本格式
WritableCellFormat textformat = new WritableCellFormat(NumberFormats.TEXT);

labelformat.setAlignment(Alignment.CENTRE);
labelformat.setVerticalAlignment(VerticalAlignment.CENTRE);

textformat.setAlignment(Alignment.LEFT);
textformat.setVerticalAlignment(VerticalAlignment.CENTRE);

sheet.setRowView(0, 400);
sheet.setColumnView(0, 20);
sheet.setColumnView(1, 15);
sheet.setColumnView(2, 30);
sheet.setColumnView(3, 30);
sheet.setColumnView(4, 30);
sheet.setColumnView(5, 30);
sheet.setColumnView(6, 30);
sheet.setColumnView(7, 30);
sheet.setColumnView(8, 30);

Label label = new Label(0, 0, "组别名称",labelformat);
sheet.addCell(label);

label = new Label(1, 0, "月份(格式:2013-07)",labelformat);
sheet.addCell(label);

label = new Label(2, 0, "目标1（档位：元）",labelformat);
sheet.addCell(label);

label = new Label(3, 0, "目标2（档位:元）",labelformat);
sheet.addCell(label);

label = new Label(4, 0, "目标3（档位:元）",labelformat);
sheet.addCell(label);

label = new Label(5, 0, "目标4（档位:元）",labelformat);
sheet.addCell(label);

label = new Label(6, 0, "目标5（档位:元）",labelformat);
sheet.addCell(label);

label = new Label(7, 0, "目标6（档位:元）",labelformat);
sheet.addCell(label);

label = new Label(8, 0, "每日平均通时目标业绩（分钟）",labelformat);
sheet.addCell(label);

for(int i=1;i<2001;i++){//生成2000行记录的文本框
label = new Label(0, i, "",textformat);
sheet.addCell(label);

label = new Label(1, i, "",textformat);
sheet.addCell(label);

label = new Label(2, i, "",textformat);
sheet.addCell(label);

label = new Label(3, i, "",textformat);
sheet.addCell(label);

label = new Label(4, i, "",textformat);
sheet.addCell(label);

label = new Label(5, i, "",textformat);
sheet.addCell(label);

label = new Label(6, i, "",textformat);
sheet.addCell(label);

label = new Label(7, i, "",textformat);
sheet.addCell(label);

label = new Label(8, i, "",textformat);
sheet.addCell(label);

}

book.write();
book.close();

return null;
}