Lägga till HTML Rich Text inuti Cell
Contents
[
Hide
]
Aspose.Cells stödjer konvertering av Microsoft Excel-inriktad HTML till XLS/XLSX-format. Det innebär att HTML som genereras av Microsoft Excel kan konverteras tillbaka till XLS/XLSX med hjälp av Aspose.Cells.
Likadant, om det finns enkel HTML, kan Aspose.Cells konvertera den till HTML Rich Text. Aspose.Cells erbjuder Cell.setHtmlString(string)-metoden som kan ta sådan enkel HTML och konvertera den till formaterad celltext.
Nedan kodprov visar hur du lägger till HTML-rich text inuti cellen. Se skärmbilden av den resulterande Excel-filen.
This file contains hidden or 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
| const path = require("path"); | |
| // The path to the documents directory. | |
| const dataDir = path.join(__dirname, "data"); | |
| const AsposeCells = require("aspose.cells.node"); | |
| const workbook = new AsposeCells.Workbook(); | |
| const worksheet = workbook.getWorksheets().get(0); | |
| const cell = worksheet.getCells().get("A1"); | |
| cell.setHtmlString("<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"); |