Remove Unused Styles inside the Workbook with Node.js via C++

Unused styles in Excel files not only take up space but also cause performance issues while converting to different formats like PDF, HTML, etc. Aspose.Cells provides the Workbook.removeUnusedStyles() to remove all the unused styles inside the workbook.

The following code explains the usage of Workbook.removeUnusedStyles(). The code loads the template excel file which you can download from the provided link. It contains an unused style named AsposeStyle; this style and all other unused styles will be removed after the execution of the code.

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

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "Template-With-Unused-Custom-Style.xlsx");

// Load template excel file containing unused styles
const workbook = new AsposeCells.Workbook(filePath);

// Remove all unused styles inside the template this will also remove AsposeStyle which is an unused style inside the template
workbook.removeUnusedStyles();

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