Ignore blank cells

Sep 5, 2013 at 3:00 PM
Hi All,

I have created the excel charts using EPPLUS, it works very well. But I have faced some small issues.
  1. Is there any way to remove the blank cells from the excel range
    dataSheet.Cells["B02:B26"]
  2. remove the empty series from the chart when the chart getting populated using the following code
    chart.Series.Add(dataSheet.Cells["C02:C26"], dataSheet.Cells["B02:B26"]);
Please let me know, is there any way or work around to overcome the above issues.

Thanks,
Gopi