This project has moved and is read-only. For the latest updates, please go here.

Ignore blank cells

Sep 5, 2013 at 4: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
  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.