Apply partial styling to text in excel cell using EPpplus

Question

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.

Answer 1

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();
}