<%@ page language=“java” pageEncoding=“GBK” %>
<%@page import=“cn.project.attendance.report.dao.impl.SearchAttendanceImpl” %>
<%@page import=“cn.project.attendance.report.entity.attendance” %>
<%@page import=“jxl.Workbook” %>
<%@page import=“jxl.format.UnderlineStyle” %>
<%@page import=“jxl.format.VerticalAlignment” %>
<%@ page import=“jxl.write.*” %>
<%@ page import=“weaver.general.BaseBean” %>
<%@ page import=“weaver.general.Util” %>
<%@ page import=“java.io.File” %>
<%@ page import=“java.io.FileInputStream” %>
<%@ page import=“java.io.FileOutputStream” %>
<%@ page import=“java.io.OutputStream” %>
<%@ page import=“java.text.SimpleDateFormat” %>
<%@ page import=“java.util.Date” %>
<%@ page import=“java.util.List” %>
<%
BaseBean bae = new BaseBean();
//定义Excel文件路径
String filePathName = new SimpleDateFormat(“yyyyMMddHHmmss”).format(new Date()) + “.xls”;
String filePath = application.getRealPath("/") + “report\signfile\” + filePathName;
String formDate = Util.null2String(request.getParameter(“formDate”)); //开始日期
String toDate = Util.null2String(request.getParameter(“toDate”)); //结束日期
String userid = Util.null2String(request.getParameter(“userid”)); //结束日期
String cuserid = Util.null2String(request.getParameter(“cuserid”));// 当前用户id
String usekind = Util.null2String(request.getParameter(“usekind”));// 用工性质
String departmentId = Util.null2String(request.getParameter(“departmentId”));// 结束日期
BaseBean base = new BaseBean();
OutputStream os = null;
try {
os = new FileOutputStream(filePath);
// 打开文件
WritableWorkbook book = Workbook.createWorkbook(os);
// 生成名为“第一页”的工作表,参数0表示这是第一页
WritableSheet sheetOne = book.createSheet(“考勤统计报表”, 0);
/**
* 定义单元格样式
*/
WritableFont wf_title = new WritableFont(WritableFont.ARIAL, 20, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); // 定义格式 字体 下划线 斜体 粗体 颜色
WritableFont wf_head = new WritableFont(WritableFont.ARIAL, 11, WritableFont.NO_BOLD, false, UnderlineStyle.NO