title: How convert stream excel file to datatable C#?
body: <p>I use Epplus to reading xlsx files from stream.</p>
  
  <p>It has a bug , it cant read some columns in my workbook.How can read xlsx files from stream to datatable without epplus ?</p>
  
  <p>my older code:</p>
  
  <pre><code> public static DataSet ReadExcelFile(Stream stream)
      {
          try
          {
              //2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
              IExcelDataReader excelReader =    
                               ExcelReaderFactory.CreateOpenXmlReader(stream);
              //...
              DataSet result = excelReader.AsDataSet();
  
              return result;
  
          }
          catch (Exception x)
          {
              throw x;
          }
      }
  </code></pre>
  
  <p>I didnt report it, but i tried so much combinations.If there are empty columns in worksheet ,epplus reader cant read correctly column values.</p>