Class FontSetting

FontSetting class

Represents a range of characters within the cell text.

public class FontSetting

Constructors

NameDescription
FontSetting(int, int, WorksheetCollection)

Properties

NameDescription
Font { get; }Returns the font of this object.
Length { get; }Gets the length of the characters.
StartIndex { get; }Gets the start index of the characters.
TextOptions { get; }Returns the text options.
virtual Type { get; }Gets the type of text node.

Methods

NameDescription
SetWordArtStyle(PresetWordArtStyle)Sets the preset WordArt style.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;
    using System.Drawing;

    public class FontSettingDemo
    {
        public static void FontSettingExample()
        {
            // Instantiating a Workbook object
            Workbook workbook = new Workbook();

            // Adding a new worksheet to the Excel object
            workbook.Worksheets.Add();

            // Obtaining the reference of the newly added worksheet by passing its sheet index
            Worksheet worksheet = workbook.Worksheets[0];

            // Accessing the "A1" cell from the worksheet
            Aspose.Cells.Cell cell = worksheet.Cells["A1"];

            // Adding some value to the "A1" cell
            cell.PutValue("Visit Aspose!");

            // Getting character range
            FontSetting character = cell.Characters(6, 7);

            // Setting the font of selected characters to bold
            character.Font.IsBold = true;

            // Setting the font color of selected characters to blue
            character.Font.Color = Color.Blue;

            // Saving the Excel file
            workbook.Save("FontSettingExample.xlsx");
            workbook.Save("FontSettingExample.pdf");

        }
    }
}

See Also