Asp.Net Core 导入Excel数据到Sqlite数据库

        
        private Prize prize ;

        public async Task<IActionResult> OnPostImportAsync(IFormFile excelFile)
        {
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            string sWebRootFolder = _webHostEnvironment.WebRootPath;
            string sFileName = $"{Guid.NewGuid()}.xlsx";
            FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName));
            try
            {
                using (FileStream fs = new FileStream(file.ToString(), FileMode.Create))
                {
                    excelFile.CopyTo(fs);
                    fs.Flush();
                }
                using(ExcelPackage package = new ExcelPackage(file))
                {
                    StringBuilder sb = new StringBuilder();
                    ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
                    int rowCount = worksheet.Dimension.Rows;
                    int colCount = worksheet.Dimension.Columns;
                    //bool bheaderRow = true;
                    for(int row = 2; row <= rowCount; row++)
                    {
                        prize = new Prize
                        {
                            prizeid = worksheet.Cells[row, 1].Value.ToString(),
                            prizename = worksheet.Cells[row, 2].Value.ToString(),
                            point = Convert.ToInt32(worksheet.Cells[row, 3].Value),
                            number = Convert.ToInt32(worksheet.Cells[row, 4].Value),
                            totalpoint = Convert.ToInt64(worksheet.Cells[row, 5].Value)
                        };
                        _context.Prizes.Add(prize);
                    }
                    await _context.SaveChangesAsync();
                    return Page();
                }
            }
            catch(Exception ex)
            {
                return Content(ex.Message);
            }
        }