Interface IFont

Interface for cell font value

Namespace: IronXL.Styles
Assembly: IronXL.dll
Syntax
public interface IFont

Controlling the typeface of an Excel cell in C# runs through IFont. It describes the font applied to a cell or range, the family, size, weight, and decoration, and is the part of a cell's style a developer touches whenever text needs to stand out as a heading, a total, or a flagged value. It pairs with the borders and fill on the same cell to produce the finished look.

A developer reaches IFont through IStyle.Font, the get-only property on the style returned by Cell.Style or Range.Style. There is no separate construction step: read .Style.Font and assign to its members, and assigning through a range's style applies the font to every cell in that range at once. This keeps header rows and labeled columns consistent without per-cell code.

The members map closely to Excel's font dialog. Name sets the typeface and Height the point size, while Bold and Italic control the weight and slant a heading or total usually needs. Underline takes a FontUnderlineType for single or double underlining, Strikeout draws a line through the text for struck-out values, and FontScript raises or lowers text for superscript and subscript. Color is set either through the Color string property or the SetColor method, which accepts a Color value or an RGB string for convenience, so a developer can pass whichever form is already on hand. Because IFont is reached through IStyle.Font, the usual idiom chains the two: range.Style.Font.Bold = true, and the same font members carry over whether the target is one cell or a whole range.

using IronXL;

WorkBook workbook = WorkBook.Load("report.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
IFont font = sheet["A1"].Style.Font;
font.Name = "Calibri";
font.Height = 14;
font.Bold = true;
font.SetColor("#C00000");

The cell font size how-to covers sizing and weight, the style cells, borders, and fonts example shows fonts alongside the rest of a cell's styling, and the border and alignment how-to covers the borders and layout that pair with a font on the same style.

Properties

Bold

Property that indicates if cell font is bold

Declaration
bool Bold { get; set; }
Property Value
Type Description
System.Boolean

Color

Property that returns font color in rgb format.

Declaration
string Color { get; set; }
Property Value
Type Description
System.String

FontScript

Gets or sets script property of font. Also take a look at FontScript to get list of available options

Declaration
FontScript FontScript { get; set; }
Property Value
Type Description
FontScript

Height

Gets or sets font size in px

Declaration
short Height { get; set; }
Property Value
Type Description
System.Int16

Italic

Property that indicates if cell font is italic

Declaration
bool Italic { get; set; }
Property Value
Type Description
System.Boolean

Name

Gets or sets font name

Declaration
string Name { get; set; }
Property Value
Type Description
System.String

Strikeout

Get whether to use a strikeout horizontal line through the text or not

Declaration
bool Strikeout { get; set; }
Property Value
Type Description
System.Boolean

Underline

Gets or sets underline property of font. Also take a look at FontUnderlineType to get list of available options

Declaration
FontUnderlineType Underline { get; set; }
Property Value
Type Description
FontUnderlineType

Methods

SetColor(Color)

Method for setting font color with Color value

Declaration
void SetColor(Color color)
Parameters
Type Name Description
IronSoftware.Drawing.Color color

Color value

SetColor(String)

Method for setting font color with the rgb string.

Declaration
void SetColor(string rgb)
Parameters
Type Name Description
System.String rgb

Color rgb value