How can I create multistyled cell with EPPlus library for Excel

calendar_today Asked Apr 2, 2012
thumb_up 13 upvotes
history Updated April 16, 2026

Question posted 2012 · +12 upvotes

I use EPPlus for Excel file generation.

I mean I need to convert HTML text (bold, italic, font color,name,size parameters) to Excel Cell. I suppose it needs to create multistyled cell, like:

cell text is “hello!” style I want is:

he – bold ll – italic o! – red colored font

or (more complex)

hello! – bold ll – italic (also bold) o! – red colored (also bold)

I know about MS OpenXML library (it allows me do what I need). This is good but bit more complex library for implementation.

Thanks.

Accepted answer +13 upvotes

Solved! I can use that:

FileInfo fi = new FileInfo(@"c:Book1.xlsx");

      using (ExcelPackage package = new ExcelPackage(fi))
      {
        // add a new worksheet to the empty workbook
        ExcelWorksheet worksheet = package.Workbook.Worksheets["Inv"];
        //Add the headers

        worksheet.Cells[2, 1].IsRichText = true;
        ExcelRichText ert = worksheet.Cells[2, 1].RichText.Add("bugaga");
        ert.Bold = true;
        ert.Color = System.Drawing.Color.Red;
        ert.Italic = true;

        ert = worksheet.Cells[2, 1].RichText.Add("alohaaaaa");
        ert.Bold = true;
        ert.Color = System.Drawing.Color.Purple;
        ert.Italic = true;

        ert = worksheet.Cells[2, 1].RichText.Add("mm");
        ert.Color = System.Drawing.Color.Peru;
        ert.Italic = false;
        ert.Bold = false;


        package.Save();
      }

Excel VBA objects referenced (3)

Top excel Q&A (6)

+13 upvotes ranks this answer #54 out of 167 excel solutions on this site .
excel