Adding HTML Rich Text inside the Cell
Contents
[
Hide
]
Aspose.Cells for Python via .NET supports converting Microsoft Excel oriented HTML into XLS/XLSX format. It means, the HTML generated by Microsoft Excel can be converted back to XLS/XLSX format using Aspose.Cells for Python via .NET.
Similarly, if there is some simple HTML, Aspose.Cells for Python via .NET can convert it into HTML Rich Text. Aspose.Cells for Python via .NET provides Cell.html_string property which can take such a simple HTML and convert it to formatted cell text.
Below code sample shows you how to add HTML rich text inside the cell. Please see the screenshot of the output Excel file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| workbook = Workbook() | |
| worksheet = workbook.worksheets[0] | |
| cell = worksheet.cells.get("A1") | |
| cell.html_string = "<Font Style=\"FONT-WEIGHT: bold;FONT-STYLE: italic;TEXT-DECORATION: underline;FONT-FAMILY: Arial;FONT-SIZE: 11pt;COLOR: #ff0000;\">This is simple HTML formatted text.</Font>" | |
| workbook.save(dataDir + "output_out.xlsx") |