Interface IFont
Interface for cell font value
Namespace: IronXL.Styles
Assembly: IronXL.dll
Syntax
public interface IFontControlling 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 |