NPOI操作之一EXCEL数据导入数据库

 HSSFWorkbook hssfworkbook;

         public void ExcelDataToDataBase()

         {

             string filePath = HttpContext.Current.Server.MapPath("~/123.xls");

             DAL.TodaySoftHRAMSContext context = new DAL.TodaySoftHRAMSContext();

             #region//初始化信息

             try

             {

                 using (FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.Read))

                 {

                     hssfworkbook = new HSSFWorkbook(file);

                 }

             }

             catch (Exception e)

             {

                 throw e;

             }

             #endregion

             NPOI.SS.UserModel.ISheet sheet = hssfworkbook.GetSheetAt();

             System.Collections.IEnumerator rows = sheet.GetRowEnumerator();

             ArchivesBase archivesBase = new ArchivesBase();

             while (rows.MoveNext())

             {

                 HSSFRow row = (HSSFRow)rows.Current;

                 archivesBase.PeopleName = row.Cells[].ToString().Trim();

                 if (archivesBase.PeopleName == "")

                 {

                     continue;

                 }

                 if (archivesBase.PeopleName.Length <= )

                 {

                     archivesBase.PeopleName += "*";

                 }

                 archivesBase.PeopleSex = "";

                 archivesBase.AddTime = DateTime.Now;

                 archivesBase.GraduateYear = ;

                 context.ArchivesBases.Add(archivesBase);

                 context.SaveChanges();

             }

         }