Lägga till HTML Rich Text inuti Cell

Nedan kodprov visar hur du lägger till HTML-rich text inuti cellen. Se skärmbilden av den resulterande Excel-filen.

todo:image_alt_text

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");

Relaterade artiklar