public ActionResult ExportExcel()
{
try
{
var webRoot = _env.WebRootPath;
DataTable dt = new DataTable();
QuanLyCongVanContext db = new QuanLyCongVanContext();
var paht = System.IO.Path.Combine(webRoot, "Content/TempExcel/NhanSu.xlsx");
Workbook wb = new Workbook();
//Cell Cells = char.Parse(new Cell["A3"].ToString());
Worksheet ws = wb.Worksheets[0];
dt.Columns.Add("Mã nhân sự");
dt.Columns.Add("Tên");
dt.Columns.Add("Giới tính");
dt.Columns.Add("ngày sinh");
dt.Columns.Add("Địa chỉ nhà");
dt.Columns.Add("Địa chỉ cơ quan");
dt.Columns.Add("Điện thoại");
dt.Columns.Add("Mã phòng");
List <NhanSu> listns = new List <NhanSu>();
listns = db.NhanSu.ToList();
string listnss = "";
if (listns.Count > 0)
{
listnss = String.Join(",", listns.Select(x => x.ToString()).ToArray());
}
var ob = new NhanSuRepository();
var data = ob.GetAll();
foreach (NhanSu item in data)
{
dt.Rows.Add(item.MaNhanSu, item.Ten, item.GioiTinh, Convert.ToDateTime(item.NgaySinh), item.DiaChiNR, item.DiaChiCQ, item.DienThoai, item.MaPhong);
}
string filename = "DanhSachNhanSu" + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + ".xlsx";
string folderName = "/assets/Excel/";
var file = System.IO.Path.Combine(webRoot + folderName + filename);
if (!System.IO.Directory.Exists(folderName))
{
System.IO.Directory.CreateDirectory(folderName);
}
ws.Cells.ImportDataTable(dt, false, 2, 0);
wb.Save(file);
return(Json(folderName + filename));
}
catch (Exception ex)
{
throw ex;
}
}