struts action

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;
    }

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值