以EXCEL形式导出数据

//1.前端事件

//导出
function exportViceCard(){
var creatm = $("#creatm1").val();
var creaty = $("#creaty1").val();
var orgname = $("#orgname1").val();
var sjname = $("#subject1").val();
window.location.href = sname+"/BudgetReportController/exportViceCard?creatm="+creatm+"&creaty="+creaty+"&orgname="+orgname+"&sjname="+sjname;
}

//后端逻辑

@RequestMapping("exportViceCard")
public void exportViceCard() {
String excelName = "预算报表信息导出";
BaseArgument res = new BaseArgument();
BudgetReport report = new BudgetReport();
RefObject.setValue(report, request);
report.setPage(1);
report.setRows(Integer.MAX_VALUE);
res = service.exportexcel(report);
if(res.isSuccess()){
List<BudgetReport> list = (List<BudgetReport>) res.getDataForRtn();
ExcelUtil excelUtil = new ExcelUtil();
String[][] fields = new String[4][2];
fields[0][0]="creaty";
fields[0][1]="年份";
fields[1][0]="orgname";
fields[1][1]="所属组织";
fields[2][0]="sjname";
fields[2][1]="所属科目";
fields[3][0]="budget";
fields[3][1]="预算金额";
excelUtil.createExcel2007(response, excelName, fields, list);

}

}