Apply partial styling to text in excel cell using EPpplus

c#, epplus, epplus-4, excel

Solution

You should try to use ExcelRichText class. For example:

var newFile = new FileInfo("example.xlsx");
using (var package = new ExcelPackage(newFile))
{
    var worksheet = package.Workbook.Worksheets.Add("Example");

    var boldRichText = worksheet.Cells[1, 1].RichText.Add("Hello");
    boldRichText.Bold = true;

    var normalRichText = worksheet.Cells[1, 1].RichText.Add(" World");
    normalRichText.Bold = false;

    package.Save();
}

Problem

How do I apply partial styling to contents of a cell? For example, if a cell contains the following text "Hello World". I want to make the word "Hello" bold while leaving the word "World" unchanged. I've applied styling to the entire cell just haven't been able to apply it to certain portions of a cell.

Original source