Class FontSize

A collection of fonts and there size in pixels used when determining auto widths for columns. This is used as .NET and Excel does not measure font widths in pixels in a similar way.

Inheritance

System.Object

FontSize

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class FontSize

Fields

DefaultFont

Default font used in EPPlus

Declaration

public const string DefaultFont = "Calibri"

Field Value

Type	Description
System.String

FontHeights

Dictionary containing default Font Heights in pixels for the row height calculates. You can add your own fonts and sizes here.

Declaration

public static Dictionary<string, Dictionary<float, short>> FontHeights

Field Value

Type	Description
System.Collections.Generic.Dictionary<System.String, System.Collections.Generic.Dictionary<System.Single, System.Int16>>

FontWidths

Dictionary containing Font Width in pixels. You can add your own fonts and sizes here.

Declaration

public static Dictionary<string, Dictionary<float, short>> FontWidths

Field Value

Type	Description
System.Collections.Generic.Dictionary<System.String, System.Collections.Generic.Dictionary<System.Single, System.Int16>>

NonExistingFont

Font used in EPPlus if the font name supplied cannot be found

Declaration

public const string NonExistingFont = "Arial"

Field Value

Type	Description
System.String

Methods

LoadAllFontsFromResource()

Load the fonts default heights/widths from the internal resource file

Declaration

public static void LoadAllFontsFromResource()

LoadFontsFromResource(String, Boolean)

Load the specified fonts default heights/widths from the internal resource file

Declaration

public static void LoadFontsFromResource(string fontName, bool disposeStream = true)

Parameters

Type	Name	Description
System.String	fontName	The name of the font.
System.Boolean	disposeStream	If false the stream is loading the font is kept open to load other fonts faster. It true the font-stream is disposed on exit.