Table of Contents

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
FontSize
Inherited Members

Constructors

FontSize()

public FontSize()

Fields

DefaultFont

Default font used in EPPlus

public const string DefaultFont = "Calibri"

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.