title: EPPlus with HTML input
body: <p>I have one Data table which is converting to the excel.for this i am using EPPlus dll. Here i am getting the generated excel file. but my problem is there are 2 columns are existing with rich text value. After Conversion the above column is always showing data with HTML tag. How I resolve this issue. Please help me. thanks in advance</p>
  
  <p>My code is shown below</p>
  
  <pre><code> try
   {
      using (SPSite site = new SPSite(SPContext.Current.Web.Url))
      {
          using (SPWeb web = site.OpenWeb())
          {
               DataTable dtTemp = new DataTable();
               if (ViewState["DTSource"] != null)
                   dtTemp = (DataTable)ViewState["DTSource"];
  
               using (ExcelPackage pck = new ExcelPackage())
               {
                   //Create the worksheet
                   ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet1");
                   //Load the datatable into the sheet, starting from cell A1. Print the column names on row 1
                   if (dtTemp != null &amp;&amp; dtTemp.Rows.Count &gt; 0)
                   {
                       ws.Cells["A1"].LoadFromDataTable(dtTemp, true);
                       using (ExcelRange rng = ws.Cells["A1:" + GetColumnName(dtTemp.Columns.Count) + "1"])
                       {
                           rng.Style.Font.Bold = true;
                           rng.Style.Fill.PatternType = ExcelFillStyle.Solid;
                           rng.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(79, 129, 189));
                           rng.Style.Font.Color.SetColor(Color.White);
                       }
  
                       for (int i = 0; i &lt; dtTemp.Columns.Count; i++)
                       {
                           if (dtTemp.Columns[i].DataType.FullName.Contains("DateTime"))
                           {
                               ws.Cells[2, i + 1, dtTemp.Rows.Count + 1, i + 1].Style.Numberformat.Format = "MM/dd/yyyy";
                               ws.Column(i + 1).Width = 15;
                           }
  
                           using (ExcelRange col = ws.Cells[2, 1, 2 + dtTemp.Rows.Count, 1])
                           {
                              col.Style.Numberformat.Format = "#,##0.00";
                              col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                           }
                           using (ExcelRange col = ws.Cells[2, 4, 2 + dtTemp.Rows.Count, 4])
                           {
                               col.IsRichText = true;
                               col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
                           }
                           Page.Response.Clear();
                           Page.Response.AddHeader("content-disposition", "attachment; filename=ExceptionTracker_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx");
                           Page.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                           Page.Response.BinaryWrite(pck.GetAsByteArray());
                           Page.Response.End();
                       }
                   }
                   else
                   {
                       string script = "window.frameElement.cancelPopUp(); return false;";
                       Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Close Window", script, true);
                   }
               }
           }
       }
   }
   catch (Exception ex)
   {
        throw ex;
   }
  </code></pre>