.net core webapi execl数据导入

最新推荐文章于 2024-04-15 23:25:56 发布

Grant丶

最新推荐文章于 2024-04-15 23:25:56 发布

阅读量803

点赞数 3

分类专栏： c# .net core 文章标签： .net core

本文链接：https://blog.csdn.net/Granters/article/details/123983571

版权

c# .net core 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

.net core webapi execl数据导入

        [HttpPost]
        public async Task<IActionResult> ImportUser(IFormFile File)
        {
            if (File == null || File.Length <= 0)
            {
                return new JsonResult(new { success = false, msg = "请选择导入文件！", result = "" });
            }


            if (!Path.GetExtension(File.FileName).Equals(".xlsx", StringComparison.OrdinalIgnoreCase))
            {
                return new JsonResult(new { success = false, msg = "请选择导入文件为.xlsx的后缀名!", result = "" });
            }

            try
            {
                using (var stream = new MemoryStream())
                {
                    await File.CopyToAsync(stream);

                    using (var package = new ExcelPackage(stream))
                    {

                        StringBuilder sb = new StringBuilder();
                        ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
                        int rowCount = worksheet.Dimension.Rows;
                        int ColCount = worksheet.Dimension.Columns;


                        for (int row = 2; row <= rowCount; row++)
                        {
                            UserInfo userInfo = new UserInfo();
                            for (int col = 1; col <= ColCount; col++)
                            {
                                switch (col)
                                {
                                    case 1:
                                        userInfo.userCode = worksheet.Cells[row, col].Value.ToString();
                                        break;
                                    case 2:
                                        userInfo.userName = worksheet.Cells[row, col].Value.ToString();
                                        break;
                                    case 3:
                                        userInfo.passWard = worksheet.Cells[row, col].Value.ToString();
                                        break;
                                    case 4:
                                        userInfo.factory = worksheet.Cells[row, col].Value.ToString();
                                        break;
                                }
                            }

                            _context.UserInfo.Add(userInfo);
                        }
                        int i = await _context.SaveChangesAsync();
                        if (i > 0)
                        {
                            return new JsonResult(new { success = true, msg = "导入成功！", result = "" });
                        }
                        else
                        {
                            return new JsonResult(new { success = false, msg = "导入失败！", result = "" });
                        }
                    }
                }
            }

            catch (Exception ex)
            {
                return new JsonResult(new { success = false, msg = ex.Message, result = "" });
            }
        }