Пример #1
0
 public ActionResult Import(HttpPostedFileBase excelfile)
 {
     if (excelfile == null || excelfile.ContentLength == 0)
     {
         ViewBag.Error = "請選擇一個excel檔案! <br />";
         return(View("Index"));
     }
     else
     {
         if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
         {
             string path = Server.MapPath("~/Content/" + excelfile.FileName);
             if (System.IO.File.Exists(path))
             {
                 System.IO.File.Delete(path);
             }
             excelfile.SaveAs(path);
             // Read Data from excel file
             Excel.Application   application    = new Excel.Application();
             Excel.Workbook      workbook       = application.Workbooks.Open(path);
             Excel.Worksheet     worksheet      = workbook.ActiveSheet;
             Excel.Range         range          = worksheet.UsedRange;
             List <AttendRecord> listAttRecords = new List <AttendRecord>();
             for (int row = 2; row <= range.Rows.Count; row++)
             {
                 AttendRecord r = new AttendRecord();
                 r.SID         = ((Excel.Range)range.Cells[row, 1]).Text;
                 r.Years       = ((Excel.Range)range.Cells[row, 2]).Text;
                 r.Term        = ((Excel.Range)range.Cells[row, 3]).Text;
                 r.VacType     = ((Excel.Range)range.Cells[row, 4]).Text;
                 r.ClassCounts = ((Excel.Range)range.Cells[row, 5]).Text;
                 listAttRecords.Add(r);
             }
             ViewBag.ListAttendRecord = listAttRecords;
             return(View("Success"));
         }
         else
         {
             ViewBag.Error = "檔案型態不正確! <br/>";
             return(View("Index"));
         }
     }
 }
Пример #2
0
 public Task <int> SendMailAsync(AttendRecord record)
 {
     return(Task.FromResult(1));
 }