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.

todo:image_alt_text

Sample Code

Formatting List Object Read and Write Table with Query Table Data Source