这个是dll 的下载地址 http://u.115.com/file/f8f096039c ExcelLibrary.dll 提取码f8f096039c
添加引用后 using ExcelLibrary.Office.Excel;
string file = HttpContext.Current.Server.MapPath("/manage/hr/upload/" + HttpUtility.UrlEncode(System.DateTime.Now.ToString()+".xls"));
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Sheet1");
//for (int col = 0; col < tab.Columns.Count; col++)
//{
//worksheet.Cells[0, col] = new Cell(tab.Columns[col].ColumnName);
worksheet.Cells[0, 0] = new Cell("考勤ID");
worksheet.Cells[0, 1] = new Cell("人员编号");
worksheet.Cells[0, 2] = new Cell("姓名");
worksheet.Cells[0, 3] = new Cell("考勤日期");
worksheet.Cells[0, 4] = new Cell("早上打卡时间");
worksheet.Cells[0, 5] = new Cell("中午打卡时间");
worksheet.Cells[0, 6] = new Cell("下午打卡时间");
worksheet.Cells[0, 7] = new Cell("晚上加班打卡时间");
worksheet.Cells[0, 8] = new Cell("晚上下班打卡时间");
worksheet.Cells[0, 9] = new Cell("打卡方式");
worksheet.Cells[0, 10] = new Cell("登记编号");
worksheet.Cells[0, 11] = new Cell("考勤设备编号");
worksheet.Cells[0, 12] = new Cell("考勤标示");
worksheet.Cells[0, 13] = new Cell("操作员");
worksheet.Cells[0, 14] = new Cell("考勤备注");
worksheet.Cells[0, 15] = new Cell("考勤状态");
worksheet.Cells[0, 16] = new Cell("早上打卡状态");
worksheet.Cells[0, 17] = new Cell("中午打卡状态");
worksheet.Cells[0, 18] = new Cell("下午打卡状态");
worksheet.Cells[0, 19] = new Cell("晚上加班打卡状态");
worksheet.Cells[0, 20] = new Cell("晚上下班打卡状态");
//}
for (int rowIndex = 0; rowIndex < tab.Rows.Count; rowIndex++)
{
for (int colIndex = 0; colIndex < tab.Columns.Count; colIndex++)
{
worksheet.Cells[rowIndex + 1, colIndex] = new Cell(tab.Rows[rowIndex][colIndex].ToString());
}
}
workbook.Worksheets.Add(worksheet);
workbook.Save(file);
FileInfo info = new FileInfo(file);
long size = 0;
if (info.Exists)
size = info.Length;
HttpContext.Current.Response.AddHeader("content-type", "application/x-msdownload;");
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(System.DateTime.Now.ToString() + ".xls"));
HttpContext.Current.Response.AddHeader("content-length", size.ToString());
HttpContext.Current.Response.WriteFile(file, 0, size);