Excel report read using Web Api

Hi,
Check below code

        [HttpPost]
        public IActionResult ReadExcel([FromForm] IFormFile file)
        {
            if (file == null || file.Length == 0)
            {
                return BadRequest("File not provided");
            }

            // Read the file into a MemoryStream
            var stream = new MemoryStream();
            file.CopyTo(stream);
            stream.Position = 0;

            // Detect the file type
            IWorkbook workbook;
            if (file.FileName.EndsWith(".xls"))
            {
                workbook = new HSSFWorkbook(stream);
            }
            else if (file.FileName.EndsWith(".xlsx"))
            {
                workbook = new XSSFWorkbook(stream);
            }
            else
            {
                return BadRequest("Invalid file type. Only .xls and .xlsx files are supported.");
            }

            // Get the first sheet
            var sheet = workbook.GetSheetAt(0);

            // Iterate through the rows
            var rows = sheet.GetRowEnumerator();
            while (rows.MoveNext())
            {
                var row = (IRow)rows.Current;

                // Iterate through the cells
                var cells = row.GetEnumerator();
                while (cells.MoveNext())
                {
                    var cell = (ICell)cells.Current;

                    // Do something with the cell value
                    var cellValue = cell.ToString();
                }
            }
            return Ok();
        }

You can check article from below link also for detail explanation.
 https://www.c-sharpcorner.com/article/read-posted-excel-file-from-ajax-using-npoi-in-asp-mvc/.

Regards,
Pasang