How do I display HTML table from code in excel, EPPLUS ?

See more:

C#

.NET

HTML5

Office365

Excel-2016

Hi,
I am trying to insert a custom HTML table from a code to excel. However, it does not work from the backend side. I always get a raw table string in the cell; however, it works when I open a file and manually copy and paste the cell's value somewhere else, then I get my custom table.

I've been searching for a solution for a few days now, but nothing works for me.

I will appreciate any suggestions.

What I have tried:

string htmlTable = "<table class=\"MsoTableGrid\" border=\"1\" cellspacing=\"0....TABLE CONTENT ETC. </table>

using (var package = new ExcelPackage(file))
{
    var worksheet = package.Workbook.Worksheets.Add("ReportNamePlaceHolder");

    
    worksheet.Cells["A1"].IsRichText = true ;
    worksheet.Cells["A1"].RichText.Text = htmlTable;
   
   
    worksheet.Cells["A4"].Value = htmlTable;

    package.Save();
    package.Dispose();

}