FontException: No fonts found installed on the machine.

[TravisTroyer]

I have an Azure Function from which I'd like to build spreadsheets. I'm using the Flex plan, which only supports Linux, and I get the error below when I try to auto size the columns. I understand why it's happening, but I'm wondering whether there's a way I can package fonts with my application to remedy the situation.

SixLabors.Fonts.FontException: No fonts found installed on the machine.
   at NPOI.SS.Util.SheetUtil.IFont2FontImpl(FontCacheKey cacheKey)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at NPOI.SS.Util.SheetUtil.IFont2Font(IFont font1)
   at NPOI.SS.Util.SheetUtil.GetDefaultCharWidth(IWorkbook wb)
   at NPOI.SS.Util.SheetUtil.GetColumnWidth(ISheet sheet, Int32 column, Boolean useMergedCells, Int32 firstRow, Int32 lastRow, Int32 maxRows)
   at NPOI.SS.Util.SheetUtil.GetColumnWidth(ISheet sheet, Int32 column, Boolean useMergedCells, Int32 maxRows)
   at NPOI.XSSF.UserModel.XSSFSheet.AutoSizeColumn(Int32 column, Boolean useMergedCells)
   at NPOI.XSSF.UserModel.XSSFSheet.AutoSizeColumn(Int32 column)
   at Doctelligent.Core.Export.ReceiptExporter.GetBytes() in M:\doctelligent\src_dotnet\Doctelligent.Core\Export\ReceiptExporter.cs:line 62
   at Doctelligent.Api.Functions.ExportHttpFunction.Run(HttpRequest req) in M:\doctelligent\src_dotnet\Doctelligent.Api.Functions\Functions\ExportHttpFunction.cs:line 74

[tonyqus]

Please read #981

[TravisTroyer]

I appreciate the quick response. Unfortunately, it doesn't apply in my situation, because the Flex consumption plan doesn't allow running from a custom container.

I was able to get around the problem by embedding the font as a resource, and then installing like this:

if (RuntimeInformation.IsOSPlatform(OSPlatform.Linux))
{
	var homeDirectory = Environment.GetEnvironmentVariable("HOME");
	var fontDirectory = Path.Combine(homeDirectory, ".fonts");

	if (!Directory.Exists(fontDirectory))
		Directory.CreateDirectory(fontDirectory);

	var fontPath = Path.Combine(fontDirectory, "arial.ttf");

	if (!File.Exists(fontPath))
	{
		var fontBytes = (byte[])Resources.ResourceManager.GetObject("arial");
		await File.WriteAllBytesAsync(fontPath, fontBytes);
	}
}