How to get OData Connection Information with Node.js via C++

Get OData Connection Information

There might be cases where developers need to extract OData information from the Excel file. Aspose.Cells for Node.js via C++ provides the Workbook.getDataMashup() property which returns the DataMashup information present in the Excel file. This information is represented by the DataMashup class. The DataMashup class provides the DataMashup.getPowerQueryFormulas() property that returns the PowerQueryFormulaCollection collection. From the PowerQueryFormulaCollection, you can get access to PowerQueryFormula and PowerQueryFormulaItem.

The following code snippet demonstrates the use of these classes to retrieve the OData information.

The Source file used in the following code snippet is attached for your reference.

Source File

Sample 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, "ODataSample.xlsx");
// Loads the workbook which contains hidden external links
const workbook = new AsposeCells.Workbook(filePath);
const PQFcoll = workbook.getDataMashup().getPowerQueryFormulas();

for (let i = 0; i < PQFcoll.getCount(); i++) {
const PQF = PQFcoll.get(i);
console.log("Connection Name: " + PQF.getName());
const PQFIcoll = PQF.getPowerQueryFormulaItems();

for (let j = 0; j < PQFIcoll.getCount(); j++) {
const PQFI = PQFIcoll.get(j);
console.log("Name: " + PQFI.getName());
console.log("Value: " + PQFI.getValue());
}
}

Console Output

Connection Name: Orders

Name: Source

Value: OData.Feed("https://services.odata.org/V3/Northwind/Northwind.svc/", null, [Implementation="2.0"])

Name: Orders_table

Value: Source{[Name="Orders",Signature="table"]}[Data]

Reading and Writing Query Table of Worksheet with Node.js via C++ Read and Write External Connection of XLS and XLSB files with Node.js via C++