Remove dbnull/empty cells from my datatable C#

See more:

C#

ASP.NET

MS-Excel

DataTable

, +

Hi guys

I have a query that retrieves data from the database through a Storedproceduer. The data is then stored into a DataTable and then to a session and afterwards export to excel through a button click.
My issue is that my table has dozens of NUll values and I want them removed before exporting them to excel.

This is how my code looks like with everything:
DB methode:

public void GetData()
       {
        try
        {
            DataTable dt = new DataTable();
            SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            connection.Open();
            using (SqlCommand sqlCmd = new SqlCommand("DAtabase.dbo.SP_EXPORT", connection)) //Extract data: no cons first and cons after
            {
                sqlCmd.CommandType = CommandType.StoredProcedure;
                using (SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd))
                {
                    sqlDa.Fill(dt);
                    if (dt.Rows.Count > 0)
                    {
                        Session["TaskTable"] = dt;
                    }
                }
            }
        }
        catch (Exception)
        {
            Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('No data found, try again');", true);
        }
    }

My Export function:

<pre>protected void Button_Export_DS_Click(object sender, EventArgs e)
    {
        if (dtNew.Rows.Count > 0)
            {
                MemoryStream ms = new MemoryStream();
                int i = 1;
                using (ExcelPackage package = new ExcelPackage(ms))
                {
                    ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet" + i++);
                    worksheet.Cells["A1"].LoadFromDataTable(dtNew, true);
                    worksheet.Cells.AutoFitColumns();

                    Response.Clear();
                    package.SaveAs(Response.OutputStream);
                    Response.AddHeader("content-disposition", "attachchment; filename=DS_Export.xls");
                    Response.Charset = "";
                    Response.ContentType = "application/vnd.xls";
                    Response.End();
                }
            }

    }

What I have tried:

I have looked at various solutions through the internet without success, I hope someone can help with this.
It's not possible to change the SQL code, since it's working with a pvt function which is based on dates!