在将电子表格渲染为HTML时设置默认字体

Aspose.Cells允许在将电子表格渲染为HTML时设置默认字体. 请使用HtmlSaveOptions.default_font_name来实现此目的. 当电子表格中有一些单元格具有无效或不存在的字体时, 特定于HtmlSaveOptions.default_font_name属性指定的字体将进行渲染.

在将电子表格渲染为HTML时设置默认字体

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

截图显示了通过HtmlSaveOptions.default_font_name属性设置不同默认字体名称的效果.

该代码生成了使用Courier New的output HTML文件, 使用Arial的output HTML文件, 以及使用Times New Roman的output HTML文件.

示例代码

from aspose.cells import HtmlSaveOptions, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object and access first worksheet.
wb = Workbook()
ws = wb.worksheets[0]
#  Access cell B4 and add some text inside it.
cell = ws.cells.get("B4")
cell.put_value("This text has some unknown or invalid font which does not exist.")
#  Set the font of cell B4 which is unknown.
st = cell.get_style()
st.font.name = "UnknownNotExist"
st.font.size = 20
cell.set_style(st)
#  Now save the workbook in html format and set the default font to Courier New.
opts = HtmlSaveOptions()
opts.default_font_name = "Courier New"
wb.save(dataDir + "out_courier_new_out.htm", opts)
#  Now save the workbook in html format once again but set the default font to Arial.
opts.default_font_name = "Arial"
wb.save(dataDir + "out_arial_out.htm", opts)
#  Now save the workbook in html format once again but set the default font to Times New Roman.
opts.default_font_name = "Times New Roman"
wb.save(dataDir + "times_new_roman_out.htm", opts)