Export Comments while Saving Excel file to HTML

Export Comments while Saving Excel file to HTML

When Excel is converted to HTML, comments are not exported. Aspose.Cells for Python via Java provides the feature to export comments during Excel to HTML conversion. To achieve this, the API provides the HtmlSaveOptions.IsExportComments property. Setting the value of HtmlSaveOptions.IsExportComments property to True will export comments in the output HTML.

The following screenshot shows the output HTML file generated by the sample code snippet.

The following sample code demonstrates exporting comments during Excel to HTML conversion.

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

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

  # Initialize HtmlSaveOptions
  saveOptions = HtmlSaveOptions()
  saveOptions.setExportComments(True)

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