Create Style object using CellsFactory class

Create Style object using CellsFactory class

The following sample code creates Style object using CellsFactory class and then sets the Default Style of the workbook. Please download the output excel file to see the results of this code for your reference.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Create a Style object using CellsFactory class
const cf = new AsposeCells.CellsFactory();
const st = cf.createStyle();

// Set the Style fill color to Yellow
st.setPattern(AsposeCells.BackgroundType.Solid);
st.setForegroundColor(AsposeCells.Color.Yellow);

// Create a workbook and set its default style using the created Style object
const wb = new AsposeCells.Workbook();
wb.setDefaultStyle(st);

// Save the workbook
wb.save(path.join(dataDir, "output_out.xlsx"));