title: How to remove empty cells and rows from file using ExcelDataReader?
body: <p>I'm using <a href="https://github.com/ExcelDataReader/ExcelDataReader" rel="noreferrer">ExcelDataReader</a> to read excel file but the file which being processed has 16k columns and 1200 records each. In between only 52 columns are filled other are empty so I want to remove empty columns with rows.</p>
  
  <p>tried with :</p>
  
  <pre><code>var dataset = reader.AsDataSet(new ExcelDataSetConfiguration() {
      ConfigureDataTable = _ =&gt; new ExcelDataTableConfiguration() {
          FilterRow = rowReader =&gt; rowReader.Depth != 0
      }
  });
  </code></pre>
  
  <p>help will be appreciated thank you </p>