Save Workbook to Strict Open XML Spreadsheet Format with Node.js via C++

Possible Usage Scenarios

Aspose.Cells for Node.js via C++ allows you to save the workbook in Strict Open XML Spreadsheet format. For that purpose, it provides the WorkbookSettings.getCompliance() property. If you set its value to OoxmlCompliance.iso29500_2008_strict, the output Excel file will be saved in Strict Open XML Spreadsheet format.

Save Workbook to Strict Open XML Spreadsheet Format

The following sample code creates a workbook, sets the value of the WorkbookSettings.getCompliance() property to OoxmlCompliance.iso29500_2008_strict, and saves it as the output Excel file (67338272.xlsx). If you open the output Excel file in Microsoft Excel and open the Save As… dialog box, you will see its format displayed as Strict Open XML Spreadsheet, as shown in this screenshot.

Sample Code

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

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

// Create workbook.
const wb = new AsposeCells.Workbook();

// Specify - Strict Open XML Spreadsheet - Format.
wb.getSettings().setCompliance(AsposeCells.OoxmlCompliance.Iso29500_2008_Strict);

// Add message in cell B4 of first worksheet.
const b4 = wb.getWorksheets().get(0).getCells().get("B4");
b4.putValue("This Excel file has Strict Open XML Spreadsheet format.");

// Save to output Excel file.
wb.save("outputSaveWorkbookToStrictOpenXMLSpreadsheetFormat.xlsx", AsposeCells.SaveFormat.Xlsx);