telldurges says:

how to create api for this.

What API you want to create?

Please explain in more details.

Sir suppose i have an excel file in a folder i want to read that excel and save in databse that excel record ,create dynamic table with excel and save that data in database .

Hi telldurges,

To read excel from folder i have used below article.

Using IHostingEnvironment in ASP.Net Core

Then read the Excel to DataTable using the below article.

Read and Import Excel data to DataTable using ClosedXml in ASP.Net with C# and VB.Net

Refer below code.

public class HomeController : Controller
{
    private IHostingEnvironment Environment;
    public HomeController(IHostingEnvironment _environment)
    {
        Environment = _environment;
    }
    public IActionResult Index()
    {
        string filePath = Path.Combine(this.Environment.ContentRootPath, "Files\\Sample.xlsx");
        using (XLWorkbook workBook = new XLWorkbook(filePath))
        {
            IXLWorksheet workSheet = workBook.Worksheet(1);
            DataTable dt = new DataTable();
            bool firstRow = true;
            foreach (IXLRow row in workSheet.Rows())
            {
                if (firstRow)
                {
                    foreach (IXLCell cell in row.Cells())
                    {
                        dt.Columns.Add(cell.Value.ToString());
                    }
                    firstRow = false;
                }
                else
                {
                    dt.Rows.Add();
                    int i = 0;
                    foreach (IXLCell cell in row.Cells())
                    {
                        dt.Rows[dt.Rows.Count - 1][i] = cell.Value.ToString();
                        i++;
                    }
                }
            }

            // Write code to insert into database.
        }

        return View();
    }
}