Convert Excel file Stream to DataTable in C# .NET

Using ExcelDataReader library we can convert a file stream excel file to a DataTable. The excel file no need to be saved to the local drive. The sample code is given below.

    byte[] buffer = Convert.FromBase64String(fileData.Replace(' ', '+'));

    Stream stream = new MemoryStream(buffer);

    var result = this.ExcelStreamToDataSet(stream);

public DataSet ExcelStreamToDataSet(Stream stream)
{
    IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

    excelReader.IsFirstRowAsColumnNames = true;

    var ds = excelReader.AsDataSet();

    excelReader.Close();

    return ds;
}