Private Fonts
GemBox.Spreadsheet provides the FontSettings
class for specifying various font related options which are used by a rendering engine when saving a workbook to PDF, XPS or image formats, printing a workbook or converting it to XpsDocument
or ImageSource
objects.
For example, using the FontSettings.FontsBaseDirectory
property you can specify the location where GemBox.Spreadsheet's rendering engine can look for the workbook's font files. This feature is especially useful for medium trust environments, like ASP.NET applications working in Medium Level Trust, where accessing the default font directory for the operating system is restricted.
The following example shows how you can specify the location of a custom font (in this case it contains the Almonte Snow.ttf font file).

using GemBox.Spreadsheet;
class Program
{
static void Main()
{
// If using the Professional version, put your serial key below.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Private Fonts");
// Current directory contains a font file.
FontSettings.FontsBaseDirectory = ".";
worksheet.Parent.Styles.Normal.Font.Name = "Almonte Snow";
worksheet.Parent.Styles.Normal.Font.Size = 48 * 20;
worksheet.Cells[0, 0].Value = "Hello World!";
workbook.Save("Private Fonts.%OutputFileType%");
}
}
Imports GemBox.Spreadsheet
Module Program
Sub Main()
' If using the Professional version, put your serial key below.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")
Dim workbook As New ExcelFile()
Dim worksheet = workbook.Worksheets.Add("Private Fonts")
' Current directory contains a font file.
FontSettings.FontsBaseDirectory = "."
worksheet.Parent.Styles.Normal.Font.Name = "Almonte Snow"
worksheet.Parent.Styles.Normal.Font.Size = 48 * 20
worksheet.Cells(0, 0).Value = "Hello World!"
workbook.Save("Private Fonts.%OutputFileType%")
End Sub
End Module
GemBox.Spreadsheet also supports retrieving fonts that are stored as resources inside the local or referenced assembly by specifying the FontSettings.FontsBaseResourceLocation
property. Note; under this property's remarks you can find out how you can use embedded fonts.