public void DaoChuExcel(string path)         {  //path是导出的excel要保存的路径

             using (Stream fs = new FileStream(path, FileMode.Create, FileAccess.Write))

             {  //创建一个表

                 XSSFWorkbook work = new XSSFWorkbook();

                //创建页

                 ISheet sheet = work.CreateSheet("zx");

                 List<MemberInfo> list = memDal.GetAllMemberByDelFlag();

                //创建行

                 for (int i = ; i < list.Count; i++)

                 {

                     IRow row = sheet.CreateRow(i); //定义excel中的一行

                       //下面的Icell代表行中的单元格

                     ICell cell2 = row.CreateCell(, CellType.String);

                     cell2.SetCellValue(list[i].MemName);

                     ICell cell3 = row.CreateCell(, CellType.String);

                     cell3.SetCellValue(list[i].MemMobilePhone);

                     ICell cell4 = row.CreateCell(, CellType.String);

                     cell4.SetCellValue(list[i].MemAddress);

                     ICell cell5 = row.CreateCell(, CellType.Numeric);

                     cell5.SetCellValue(list[i].MemType);

                     ICell cell6 = row.CreateCell(, CellType.String);

                     cell6.SetCellValue(list[i].MemNum);

                     ICell cell7 = row.CreateCell(, CellType.String);

                     cell7.SetCellValue(list[i].MemGender);

                     ICell cell8 = row.CreateCell(, CellType.Numeric);

                     cell8.SetCellValue(list[i].MemDiscount);

                     ICell cell9 = row.CreateCell(, CellType.Numeric);

                     cell9.SetCellValue(list[i].MemMoney);

                     ICell cell10 = row.CreateCell(, CellType.Numeric);

                     cell10.SetCellValue(list[i].DelFlag);

                     ICell cell11 = row.CreateCell(, CellType.String);

                     cell11.SetCellValue(list[i].SubTime.ToShortDateString());

                     ICell cell12 = row.CreateCell(, CellType.Numeric);

                     cell12.SetCellValue(list[i].MemIntegral);

                     ICell cell13 = row.CreateCell(, CellType.String);

                     cell13.SetCellValue(list[i].MemEndTime.ToShortDateString());

                     ICell cell14 = row.CreateCell(, CellType.String);

                     cell14.SetCellValue(list[i].MemBirthday.ToShortDateString());

                 }

                 work.Write(fs);  //最后把表写入IO流中

             }

         }

  public void ReadExcel(string path)

         {

             using (Stream fs = new FileStream(path,FileMode.Open,FileAccess.Read))  //从指定路径读入excel表

             {

                 List<MemberInfo> list = new List<MemberInfo>();

             //工作表

                 IWorkbook workbook = WorkbookFactory.Create(fs);

                 //获取页

                 ISheet sheet = workbook.GetSheetAt();

                 //遍历行

                 for (int i = ; i <=sheet.LastRowNum; i++)

                 {

                     MemberInfo mem = new MemberInfo();

                    //获取行

                     IRow row = sheet.GetRow(i);

                     mem.MemName = row.GetCell().StringCellValue;

                     mem.MemMobilePhone = row.GetCell().StringCellValue;

                     mem.MemAddress = row.GetCell().StringCellValue;

                     mem.MemType = Convert.ToInt32(row.GetCell().NumericCellValue);

                     mem.MemNum = row.GetCell().StringCellValue;

                     mem.MemGender = row.GetCell().StringCellValue;

                     mem.MemDiscount = Convert.ToDouble(row.GetCell().NumericCellValue);

                     mem.MemMoney = row.GetCell().NumericCellValue;

                     mem.DelFlag = Convert.ToInt32(row.GetCell().NumericCellValue);

                     mem.SubTime =Convert.ToDateTime(row.GetCell().StringCellValue);

                     mem.MemIntegral = Convert.ToInt32(row.GetCell().NumericCellValue);

                     mem.MemEndTime = Convert.ToDateTime(row.GetCell().StringCellValue);

                     mem.MemBirthday = Convert.ToDateTime(row.GetCell().StringCellValue);

                     list.Add(mem);

                 }

                 memDal.AddMemberInfo(list);  //把数据体添加到数据库

             }

         }