见附件中的4个截图:
问题1:导图Sheet的图片,右边和下边的线丢失
问题2:前置条件Sheet有几个单元格背景和文字丢失,被隐藏了。斜线不显示。
问题3:列丢失
问题4:列丢失,宽度不对,显示走样。
BugExcel.zip (2.8 MB)
转换代码如下
//Load the sample Excel file
Workbook workbook = new Workbook(sourceFileName);
//Specify Html Save Options
HtmlSaveOptions options = new HtmlSaveOptions();
//We do not want to export document, workbook and worksheet properties
options.setExportDocumentProperties(false);
options.setExportWorkbookProperties(false);
options.setExportWorksheetProperties(false);
options.setExportSimilarBorderStyle(true);
options.setExportImagesAsBase64(false);
options.setExcludeUnusedStyles(true);
options.setExportHiddenWorksheet(false);
options.setWidthScalable(false);
options.setPresentationPreference(true);
//Specify HtmlSaveOptions - Hide Overlaid Content with CrossHideRight while saving to Html
options.setHtmlCrossStringType(HtmlCrossType.CROSS_HIDE_RIGHT);
//Export the Excel file to Html with Html Save Options
workbook.save(targetFileName, options);