Convert-Excel-to-JSON with Node.js via C++

Aspose.Cells supports converting a Workbook to JSON (JavaScript Object Notation) file.

Convert Excel Workbook to JSON

No need to wonder how to convert Excel Workbook to JSON, because Aspose.Cells for Node.js via C++ library provides the best solution. The Aspose.Cells API offers support for converting spreadsheets to JSON format. To export the workbook to JSON, pass SaveFormat.Json as the second parameter of Workbook.save(string, SaveFormat) method. You may also use JsonSaveOptions class to specify additional settings for exporting the worksheet to JSON.

The following code example demonstrates exporting an Excel Workbook to JSON. Please see the code to convert the source file to the JSON file generated by the code for reference.

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, "sample.xlsx");
// Load your source workbook
const workbook = new AsposeCells.Workbook(filePath);

// Convert the workbook to json file.
workbook.save("sample_out.json");

The following code example uses the JsonSaveOptions class to specify additional settings and demonstrates exporting an Excel Workbook to JSON. Please see the code to convert the source file to the JSON file generated by the code for reference.

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, "sample.xlsx");
// Create an options of saving the file.
const options = new AsposeCells.JsonSaveOptions();

// Set the exporting range.
options.setExportArea(AsposeCells.CellArea.createCellArea("B1", "C4"));

// Load your source workbook
const workbook = new AsposeCells.Workbook(filePath);

// Convert the workbook to json file.
workbook.save("sample_out.json", options);