GemBox.Spreadsheet is a .NET component that enables you to read, write, edit, convert, and print spreadsheet files from your .NET applications using one simple API.

ExcelCell Inline Text Formatting

Using GemBox.Spreadsheet you can apply font formatting (size, color, font type, italic and strikeout properties, different levels of boldness, underlining, subscript and superscript) to individual characters and words.

Following example shows how to format individual characters and words within a cell.

Screenshot
ExcelCell Inline Text Formatting Screenshot

See the full code below, use Run Example to execute.

using GemBox.Spreadsheet;
using System;
using System.IO;

class Sample
{
    [STAThread]
    static void Main(string[] args)
    {
        // If using Professional version, put your serial key below.
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

        ExcelFile ef = new ExcelFile();
        ExcelWorksheet ws = ef.Worksheets.Add("Inline Text Formatting");

        ws.Cells[0, 0].Value = "Inline text formatting examples:";
        ws.PrintOptions.PrintGridlines = true;

        // Column width of 20 characters.
        ws.Columns[0].Width = 20 * 256;

        ws.Cells[2, 0].Value = "This is big and red text!";

        // Apply size to 'big and red' part of text
        ws.Cells[2, 0].GetCharacters(8, 11).Font.Size = 400;

        // Apply color to 'red' part of text
        ws.Cells[2, 0].GetCharacters(16, 3).Font.Color = SpreadsheetColor.FromName(ColorName.Red);

        // Format cell content
        ws.Cells[4, 0].Value = "Formatting selected characters with GemBox.Spreadsheet component.";
        ws.Cells[4, 0].Style.Font.Color = SpreadsheetColor.FromName(ColorName.Blue);
        ws.Cells[4, 0].Style.Font.Italic = true;
        ws.Cells[4, 0].Style.WrapText = true;

        // Get characters from index 36 to the end of string
        FormattedCharacterRange characters = ws.Cells[4, 0].GetCharacters(36);

        // Apply color and underline to selected characters
        characters.Font.Color = SpreadsheetColor.FromName(ColorName.Orange);
        characters.Font.UnderlineStyle = UnderlineStyle.Single;

        // Write selected characters
        ws.Cells[6, 0].Value = "Selected characters: " + characters.Text;

        ef.Save("Inline Text Formatting.xlsx");
    }
}
Imports GemBox.Spreadsheet
Imports System.IO

Module Samples

    Sub Main()

        ' If using Professional version, put your serial key below.
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

        Dim ef As ExcelFile = New ExcelFile
        Dim ws As ExcelWorksheet = ef.Worksheets.Add("Inline Text Formatting")

        ws.Cells(0, 0).Value = "Inline text formatting examples:"
        ws.PrintOptions.PrintGridlines = True

        ' Column width of 20 characters.
        ws.Columns(0).Width = 20 * 256

        ws.Cells(2, 0).Value = "This is big and red text!"

        ' Apply size to 'big and red' part of text
        ws.Cells(2, 0).GetCharacters(8, 11).Font.Size = 400

        ' Apply color to 'red' part of text
        ws.Cells(2, 0).GetCharacters(16, 3).Font.Color = SpreadsheetColor.FromName(ColorName.Red)

        ' Format cell content
        ws.Cells(4, 0).Value = "Formatting selected characters with GemBox.Spreadsheet component."
        ws.Cells(4, 0).Style.Font.Color = SpreadsheetColor.FromName(ColorName.Blue)
        ws.Cells(4, 0).Style.Font.Italic = True
        ws.Cells(4, 0).Style.WrapText = True

        ' Get characters from index 36 to the end of string
        Dim characters As FormattedCharacterRange = ws.Cells(4, 0).GetCharacters(36)

        ' Apply color and underline to selected characters
        characters.Font.Color = SpreadsheetColor.FromName(ColorName.Orange)
        characters.Font.UnderlineStyle = UnderlineStyle.Single

        ' Write selected characters
        ws.Cells(6, 0).Value = "Selected characters: " + characters.Text

        ef.Save("Inline Text Formatting.xlsx")

    End Sub

End Module

Check next sample.