.NETCore使用EPPlus简单操作Excel(简单实现导入导出)

 1        [HttpGet]
 2         public IActionResult Export()
 3         {
 4             string sWebRootFolder = hostingEnv.WebRootPath;
 5             string sFileName = $@"qmhuangtext{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx";
 6             var path = Path.Combine(sWebRootFolder, sFileName);
 7             FileInfo file = new FileInfo(path);
 8             //构建数据
 9             List list1 = new List()
10                 {
11                     new Person{Name = "123",Sex="男"},
12                     new Person{Name = "234",Sex="男"},
13                     new Person{Name = "345",Sex="女"}
14                 };
15             if (file.Exists)
16             {
17                 file.Delete();
18                 file = new FileInfo(path);
19             }
20             using (ExcelPackage package = new ExcelPackage(file))
21             {
22              　　　　//创建sheet
23                     ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(“sheetname”);
25                     worksheet.Cells.LoadFromCollection(list1 ,true);
26                     package.Save(); //Save the workbook.
27             }
28             return File(new FileStream(Path.Combine(sWebRootFolder, sFileName), FileMode.Open), "application/octet-stream", $"excel导出测试{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
29         }

 1         /// 

 2         /// 读取sheet 内的数据进入实体
 3         /// 
 4         /// 
 5         /// 
 6         public List GetSheetValues(string filepath)
 7         {
 8             FileInfo file = new FileInfo(filepath);
 9             if (file != null)
10             {
11                 using (ExcelPackage package = new ExcelPackage(file))
12                 {
13 
14                     ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
15                     //获取表格的列数和行数
16                     int rowCount = worksheet.Dimension.Rows;
17                     int ColCount = worksheet.Dimension.Columns;
18                     var persOns= new List();
19                     for (int row = 1; row <= rowCount; row++)
20                     {
21                         Person person = new Person();
22                         person.Name = worksheet.Cells[row, 1].Value.ToString();
23                         person.Sex = worksheet.Cells[row, 2].Value.ToString();
24                         persons.Add(person);
25                     }
26                     return persons;
27                 }
28             }
29              return null;
30         }