How to Import this Excel Data Into Table

Hi Sandeep Kumar,

To import Excel data into a table in Dot net, you can utilize the ExcelDataReader library. First, install the ExcelDataReader package via NuGet Package Manager. Then, you can use the following code snippet to achieve this:

using ExcelDataReader;
using System.Data;
using System.IO;

// Read Excel file
using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read))
{
    using (var reader = ExcelReaderFactory.CreateReader(stream))
    {
        var result = reader.AsDataSet(new ExcelDataSetConfiguration()
        {
            ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true }
        });

        DataTable table = result.Tables[0]; // Assuming data is in the first sheet

        // Now you can use the 'table' to insert data into your database table
    }
}

This code snippet reads an Excel file, extracts the data, and stores it in a DataTable.

You can read your data sheet-wise using custom code