您好,
我使用以下的程式,透過 Aspose.Cells 讀取 Excel 格式的 Html 檔案(Excel 另存成 Html) ,當字型之中有設定 Wingdings 字型時,在某些TD會造成 / 字型不對。
程式如下,
var fileName = @“C:\aspose\fbu\f.html”;
var output2 = @“C:\aspose\fbu\f_out.pdf”;
var loadOptions = new HtmlLoadOptions(LoadFormat.Html);
var wb = new Workbook(fileName, loadOptions);
var worksheet = wb.Worksheets[0];
var options = new AutoFitterOptions();
options.AutoFitMergedCellsType = AutoFitMergedCellsType.EachLine;
worksheet.AutoFitRows(options);
var pageSetup = worksheet.PageSetup;
pageSetup.IsPercentScale = true;
pageSetup.Zoom = 70;
var saveOptions = new PdfSaveOptions(SaveFormat.Pdf);
saveOptions.CheckWorkbookDefaultFont = false;
wb.Save(output2, saveOptions);
f.html 及 f_out.pdf 如附件,
f.zip (111.5 KB)
有問題的地方為,o續約/增貸
f_out.png (554.9 KB)