title: Return cell with value not null using linq - Epplus
body: <p>I'm using the Linq code below to return the last filled cell in my row. However, I do not know for what reason (maybe some formatting, or something of the sort) cell with null value is being returned. Example</p>
  
  <p>My row starts at B16 and goes to AG16, the code in thesis should return AG16, but this is returning AI16, and this cell is blank, has no value, formula, nothing.</p>
  
  <p>I would like to ignore cells with the Blank Value, so to return AG16.</p>
  
  <p>I'm doing according to the code below, which returns AI16 even though it has no value</p>
  
  <pre><code>var lastRowCellValue = worksheet.Cells.Last(c =&gt; c.End.Row == 16)
  </code></pre>
  
  <ul>
  <li>16 is the line row that he will check</li>
  </ul>
  
  <p>I have already tried to use the code below, but it returns NULL instead of AG16, which is my last value cell</p>
  
  <pre><code> var lastRowCellValue = worksheet.Cells.Last(c =&gt; c.End.Row == 16).Where(c =&gt; c.Value != null);
  </code></pre>
  
  <p>What am I doing wrong?</p>