在Node.js和C++中设置默认字体以渲染电子表格为HTML
Contents
[
Hide
]
Aspose.Cells允许在将电子表格渲染为HTML时设置默认字体. 请使用HtmlSaveOptions.getDefaultFontName()来实现此目的. 当电子表格中有一些单元格具有无效或不存在的字体时, 特定于HtmlSaveOptions.getDefaultFontName()属性指定的字体将进行渲染.
在将电子表格渲染为HTML时设置默认字体
以下示例代码创建一个工作簿，并在第一个工作表的B4单元格中添加了一些文本，并将其字体设置为某个未知/不存在的字体。然后，它通过设置不同的默认字体名称，如Courier New、Arial、Times New Roman等，将工作簿保存为HTML。
截图显示通过HtmlSaveOptions.getDefaultFontName()属性设置不同默认字体名的效果。
该代码生成了使用Courier New的output HTML文件, 使用Arial的output HTML文件, 以及使用Times New Roman的output HTML文件.
示例代码
const path = require("path");
const AsposeCells = require("aspose.cells.node");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Create workbook object and access first worksheet.
const wb = new AsposeCells.Workbook();
const ws = wb.getWorksheets().get(0);
// Access cell B4 and add some text inside it.
const 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.
const 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.
const opts = new AsposeCells.HtmlSaveOptions();
opts.setDefaultFontName("Courier New");
wb.save(path.join(dataDir, "out_courier_new_out.htm"), opts);
// Now save the workbook in html format once again but set the default font to Arial.
opts.setDefaultFontName("Arial");
wb.save(path.join(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.setDefaultFontName("Times New Roman");
wb.save(path.join(dataDir, "times_new_roman_out.htm"), opts);