Get HTML5 string from Cell

Get HTML5 string from Cell

Using Aspose.Cells for Python via Java, you can get the HTML string form the cell. This can be achieved by using the getHtmlString(boolean html5) method provided by the API. If you pass false as a parameter, it will return you Normal HTML but if you pass true as a parameter, it will return HTML5 string.

The following sample code creates a workbook object and adds some text in cell A1 of the first worksheet. It then gets the Normal HTML and HTML5 string from cell A1 using the getHtmlString(boolean html5) method and prints them.

Sample Code

  # Load the Sample Workbook
  workbook = Workbook()

  # Access first worksheet
  worksheet = workbook.getWorksheets().get(0)

  # Access cell A1 and put some text inside it.
  cell = worksheet.getCells().get("A1")
  cell.putValue("This is some text.")

  # Get the Normal and Html5 strings.
  strNormal = cell.getHtmlString(False)
  strHtml5 = cell.getHtmlString(True)

  # Print the Normal and Html5 strings
  print("Normal:\r\n" + strNormal)
  print("Html5:\r\n" + strHtml5)

The following is the output generated by the above-provided code snippet.

Output

 Normal:

<Font Style="FONT-FAMILY: Arial;FONT-SIZE: 10pt;COLOR: #000000;">This is some text.</Font>

Html5:

<div Style="FONT-FAMILY: Arial;FONT-SIZE: 10pt;COLOR: #000000;">This is some text.</div>