Hide Overlaid Content while converting Excel to HTML

Hide Overlaid Content while converting Excel to HTML

When you save your Excel file to HTML, you can specify different cross types for cell strings. By default, Aspose.Cells generates HTML as per Microsoft Excel but when you change the HtmlSaveOptions.HtmlCrossStringType to CROSS_HIDE_RIGHT then it hides all the strings at the right side of the cell which are overlaid or overlapping with cell string.

The following sample code loads the sample Excel file and saves it to output HTML after setting the HtmlSaveOptions.HtmlCrossStringType as CROSS_HIDE_RIGHT. The screenshot explains how CROSS_HIDE_RIGHT affects the output HTML from the default output.

Sample Code

  source_directory = "Examples/SampleFiles/SourceDirectory/"
  output_directory = "Examples/SampleFiles/OutputDirectory/"

  # Load the Sample Workbook
  workbook = Workbook(source_directory + "sampleHidingOverlaidContentWithCrossHideRightWhileSavingToHtml.xlsx")

  # Initialize HtmlSaveOptions
  saveOptions = HtmlSaveOptions()
  saveOptions.setHtmlCrossStringType(HtmlCrossType.CROSS_HIDE_RIGHT)

  # Save the excel file.
  workbook.save(output_directory + "outputHidingOverlaidContentWithCrossHideRightWhileSavingToHtml.html", saveOptions)