Hi
Please download this Dll(free to use) from
Excel Data Reader - Read Excel files[
^]
Use this C# code :
FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
DataSet result = excelReader.AsDataSet();
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
while (excelReader.Read())
{
}
excelReader.Close();
you can assign That dataset to datagridview.
datagridview.DataSource = result;
datagridview.DataBind();
Happy coding.