Rich text in cells

The following example shows you how to create cells with rich inline text where different runs have different formatting such as bold, italic and color.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();

            // Create a rich text cell with bold + normal + italic runs
            Run run1 = new Run();
            run1.Text = new Text("Hello ");
            run1.Bold = true;
            run1.Font = "Arial";
            run1.Size = 12;

            Run run2 = new Run();
            run2.Text = new Text("World");
            run2.Bold = false;
            run2.Font = "Arial";
            run2.Size = 12;

            Run run3 = new Run();
            run3.Text = new Text(" (formatted)");
            run3.Italic = true;
            run3.Font = "Arial";
            run3.Size = 12;
            run3.Color = new DataBarColor();
            run3.Color.Color = "0000FF"; //blue

            RichTextInline richText = new RichTextInline();
            richText.Runs.Add(run1);
            richText.Runs.Add(run2);
            richText.Runs.Add(run3);

            Cell cell1 = new Cell();
            cell1.RichTextInline = richText;
            sheet["A1"] = cell1;

            // Another rich text cell with superscript
            Run normal = new Run();
            normal.Text = new Text("H");

            Run super = new Run();
            super.Text = new Text("2");
            super.RunVerticalAlignment = RunVerticalAlignment.Superscript;
            super.Size = 8;

            Run normalEnd = new Run();
            normalEnd.Text = new Text("O");

            RichTextInline formula = new RichTextInline();
            formula.Runs.Add(normal);
            formula.Runs.Add(super);
            formula.Runs.Add(normalEnd);

            Cell cell2 = new Cell();
            cell2.RichTextInline = formula;
            sheet["A2"] = cell2;

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet As New Worksheet()

        Dim run1 As New Run()
        run1.Text = New Text("Hello ")
        run1.Bold = True
        run1.Font = "Arial"
        run1.Size = 12

        Dim run2 As New Run()
        run2.Text = New Text("World")
        run2.Font = "Arial"
        run2.Size = 12

        Dim run3 As New Run()
        run3.Text = New Text(" (formatted)")
        run3.Italic = True
        run3.Font = "Arial"
        run3.Size = 12
        run3.Color = New DataBarColor()
        run3.Color.Color = "0000FF" 'blue

        Dim richText As New RichTextInline()
        richText.Runs.Add(run1)
        richText.Runs.Add(run2)
        richText.Runs.Add(run3)

        Dim cell1 As New Cell()
        cell1.RichTextInline = richText
        sheet("A1") = cell1

        Dim normal As New Run()
        normal.Text = New Text("H")

        Dim superRun As New Run()
        superRun.Text = New Text("2")
        superRun.RunVerticalAlignment = RunVerticalAlignment.Superscript
        superRun.Size = 8

        Dim normalEnd As New Run()
        normalEnd.Text = New Text("O")

        Dim formula As New RichTextInline()
        formula.Runs.Add(normal)
        formula.Runs.Add(superRun)
        formula.Runs.Add(normalEnd)

        Dim cell2 As New Cell()
        cell2.RichTextInline = formula
        sheet("A2") = cell2

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Rich text in cells

Need help? Ask our developers: