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/PhongBan.xlsx");
                Workbook             wb      = new Workbook();

                //Cell Cells = char.Parse(new Cell["A3"].ToString());
                Worksheet ws = wb.Worksheets[0];
                dt.Columns.Add("Mã phòng");
                dt.Columns.Add("Tên");;
                dt.Columns.Add("Điện  thoại");
                dt.Columns.Add("Fax");
                dt.Columns.Add("Mã nhân sự");
                List <PhongBan> listpb = new List <PhongBan>();
                listpb = db.PhongBan.ToList();
                string listpbs = "";
                if (listpb.Count > 0)
                {
                    listpbs = String.Join(",", listpb.Select(x => x.ToString()).ToArray());
                }
                var ob   = new PhongBanRepository();
                var data = ob.GetAll();
                foreach (PhongBan item in data)
                {
                    dt.Rows.Add(item.MaPhong, item.TenPhong, item.DienThoai, item.Fax, item.MaNhanSu);
                }
                string filename   = "DanhSachPhongBan" + 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;
            }
        }
        public ActionResult Index()
        {
            var listPhongBan = phongbanRepo.GetAll();

            return(View(listPhongBan));
        }