public class AttendanceAction extends ActionSupport implements
ServletResponseAware {
public String attendance_month() throws Exception {
if(queryDate == null || "".equals(queryDate)){
queryDate = new SimpleDateFormat("yyyy-MM").format(new Date());
}
teamname = URLDecoder.decode(teamname,"UTF-8");
List<String[]> list = attReportMonthService.getAttendanceData(queryDate,teamid,teamname);
ExcelUtil eu = new ExcelUtil();
String input = Thread.currentThread().getContextClassLoader()
.getResource(
File.separator + "doc" + File.separator
+ "attendance_month.xls").getFile();
Workbook wb = eu.readExcelHead(input, 5);
String fileName = "考勤统计报表-";
if (teamname != null && !"-1".equals(teamname) && !"".equals(teamname))
{
fileName = fileName + teamname + "-";
}
fileName = fileName + queryDate + ".xls";
fileName = URLEncoder.encode(fileName, "UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("application/ms-excel;charset=UTF-8");
response.setHeader("Content-Disposition",
"attachment;filename=" + fileName );
response.getOutputStream().write(eu.addExcelData(wb, list, 6));
response.getOutputStream().flush();
return null;
}
}