.net core3.1 从excel表读取（导入）数据 实战

[Route("[controller]")]
    public class TestController : Controller
    {
        [Route("[action]")]
        public async Task Index()
        {       
            return View();
        }
    
         /// 

        /// 导入excel数据
        /// 
        /// 
        [Route("ImportExcelData")]
        public ResponseData> ImportExcelData()
        {
            var response = new ResponseData>();//ResponseData为创建的一个Ajax请求返回模型，需要请告知，TableLawyer为根据数据库创建的实体模型，根据不同的数据表结构而不同

var lawyers = new List(); var files = Request.Form.Files; if (files == null || files.Count  1) { response.Result = false; response.Message = "仅支持单文件加载"; return response; } using (var stream = files.FirstOrDefault()?.OpenReadStream()) { using var ep = new ExcelPackage(stream); using var worksheet = ep.Workbook.Worksheets.FirstOrDefault(); //行 var columns = worksheet?.Dimension.Columns; //列 var rows = worksheet?.Dimension.Rows; var columnName = new Dictionary();//存储列名 for (var i = 1; i (value); break; } } if (model != null && model.LawyerId > 0) { lawyers.Add(model); } } //lawyers 即需要的数据列表，调用相关业务逻辑方法插入到数据库即可 } response.Result = lawyers.Any(); response.Data = lawyers; response.Message = response.Result ? "导入成功" : "导入失败"; return response; } }