Private Fonts
Besides installed system fonts, GemBox.Spreadsheet provides support for using private fonts and assembly fonts when saving a spreadsheet to PDF, XPS, or image formats and when printing a spreadsheet.
The following example shows how you can specify the location of a private or custom font (Almonte Snow.ttf) when saving a spreadsheet to PDF.
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");
// Set the directory path where the component will look for additional font files.
// The "." targets the current directory, so besides the installed fonts,
// the component will be able to use the fonts within the specified directory.
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")
' Set the directory path where the component will look for additional font files.
' The "." targets the current directory, so besides the installed fonts,
' the component will be able to use the fonts within the specified directory.
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 provides the GemBox.Spreadsheet supports retrieving fonts stored as resources inside the local or referenced assembly by specifying the When you add fonts as resources to your application, make sure you're setting the Build Action as Embedded resource. Or if your application is targeting .NET Framework and thus uses WPF, set it as Resource instead. The following image shows an example of a solution with font files added as embedded resources, and the following table illustrates the various base resource locations you can specify to use those fonts.FontSettings
static class where you can specify various font-related options. These options are beneficial for environments with no installed fonts (like on Docker) or where the system fonts are inaccessible and restricted (like on Medium Level Trust applications).Assembly fonts
FontSettings.FontsBaseResourceLocation
property.Used font FontSettings.FontsBaseResourceLocation
Notes Font1.ttf "/"
Font resource files are in the root of the local assembly. Font2.ttf "/MyFonts/"
Font resource files are in the subfolder of the local assembly. Font3.ttf "/MyClassLibrary;component/"
Font resource files are in the root of the referenced assembly. Font4.ttf "/MyClassLibrary;component/MyFonts/"
Font resource files are in the subfolder of the referenced assembly.