Hi,
When converting an Excel worksheet to HTML or images, I noticed some styles and content missing in the output.
Code:
var workbook = new Workbook(@".\test.xlsx"); var sheet = workbook.Worksheets[0]; var imageOrPrintOptions = new ImageOrPrintOptions() { ImageType = ImageType.Emf, OnlyArea = false, TextRenderingHint = TextRenderingHint.ClearTypeGridFit, OnePagePerSheet = false, }; sheet.PageSetup.PrintArea = "D6:CE71"; sheet.PageSetup.LeftMargin = sheet.PageSetup.RightMargin = sheet.PageSetup.TopMargin = sheet.PageSetup.BottomMargin = sheet.PageSetup.HeaderMargin = sheet.PageSetup.FooterMargin = 0; new SheetRender(sheet, imageOrPrintOptions).ToImage(0, @".\out.emf"); var htmlSaveOptions = new HtmlSaveOptions { ExportHiddenWorksheet = false, HiddenColDisplayType = HtmlHiddenColDisplayType.Remove, HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove, ExportActiveWorksheetOnly = true }; sheet.Workbook.Save(@".\out.html", htmlSaveOptions);
I can see the arrows and colours are missing in the HTML output, and the arrows are also missing in the image output.
I’ve attached my test files and a screenshot for your reference. Could you please take a look?
test.zip (217.1 KB)
image.png (112.7 KB)
Thanks,