Class FontSize¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

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.

public class FontSize

Inheritance¶

object ← FontSize

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

FontSize()¶

public FontSize()

Fields¶

DefaultFont¶

Default font used in EPPlus

public const string DefaultFont = "Aptos Narrow"

Field Value¶

string

FontHeights¶

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

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

Field Value¶

Dictionary<string, Dictionary<float, short>>

FontWidths¶

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

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

Field Value¶

Dictionary<string, Dictionary<float, short>>

NonExistingFont¶

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

public const string NonExistingFont = "Arial"

Field Value¶

string

Methods¶

LoadAllFontsFromResource()¶

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

public static void LoadAllFontsFromResource()

LoadFontsFromResource(string, bool)¶

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

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

Parameters¶

fontName string

The name of the font.

disposeStream bool

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.