将呈现电子表格时的默认字体设置为 HTML

Aspose.Cells 允许您在将电子表格呈现为 HTML 时设置默认字体。请使用HtmlSaveOptions.DefaultFontName以此目的。当电子表格中的某些单元格具有无效或不存在的字体时，此属性很有用。然后这些单元格将以指定的字体呈现HtmlSaveOptions.DefaultFontName财产。

将呈现电子表格时的默认字体设置为 HTML

以下示例代码创建一个工作簿并在第一个工作表的单元格 B4 中添加一些文本，并将其字体设置为某种未知/不存在的字体。然后通过设置不同的默认字体名称（如 Courier New、Arial、Times New Roman 等）将工作簿保存在 HTML 中。

截图显示了通过设置不同的默认字体名称的效果HtmlSaveOptions.DefaultFontName财产。

该代码生成使用 Courier New 输出 HTML 文件 ， 这用 Arial 输出 HTML和使用 Times New Roman 输出 HTML 文件.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Directory path where output HTML files are to be saved
String dataDir = Utils.getSharedDataDir(SetDefaultFontWhileRenderingSpreadsheetToHTML.class) + "Conversion/";
		
//Create workbook object.
Workbook wb = new Workbook();

//Access first WorkSheet.
Worksheet ws = wb.getWorksheets().get(0);
		
//Access cell B4 and add some text inside it.
Cell cell = ws.getCells().get("B4");
cell.putValue("This text has some unknown or invalid font which does not exist.");

//Set the font of cell B4 which is unknown.
Style st = cell.getStyle();
st.getFont().setName("UnknownNotExist");
st.getFont().setSize(20);
cell.setStyle(st);

//Now save the workbook in html format and set the default font to Courier New.
HtmlSaveOptions opts = new HtmlSaveOptions();
opts.setDefaultFontName("Courier New");
wb.save(dataDir + "out_courier_new.htm", opts);

//Now save the workbook in html format once again but set the default font to Arial.
opts.setDefaultFontName("Arial");
wb.save(dataDir + "out_arial.htm", opts);

//Now save the workbook in html format once again but set the default font to Times New Roman.
opts.setDefaultFontName("Times New Roman");
wb.save(dataDir + "out_times_new_roman.htm", opts);