Get Range with External Links using Node.js via C++

Get Range with External Links

Often Excel files access data from other Excel files using external links. Aspose.Cells for Node.js via C++ provides the option to retrieve these external links by using the Name.getReferredAreas(boolean) method. The Name.getReferredAreas(boolean) method returns an array of type ReferredArea. The ReferredArea class provides a ReferredArea.getExternalFileName() property which returns the name of the external file. The ReferredArea class exposes the following members.

• ReferredArea.getEndColumn(): The end column of the area
• ReferredArea.getEndRow(): The end row of the area
• ReferredArea.getExternalFileName(): Get the external file name if this is an external reference
• ReferredArea.isArea(): Indicates whether this is an area
• ReferredArea.isExternalLink(): Indicates whether this is an external link
• ReferredArea.getSheetName(): Indicates the sheet this reference is in
• ReferredArea.getStartColumn(): The start column of the area
• ReferredArea.getStartRow(): The start row of the area

The sample code given below demonstrates the use of the Name.getReferredAreas(boolean) method to get ranges with external links.

Sample Code

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

    // Source directory
    const sourceDir = path.join(__dirname, "data");

    // Load source Excel file
    const filePath = path.join(sourceDir, "SampleExternalReferences.xlsx");
    const workbook = new AsposeCells.Workbook(filePath);
    console.log(filePath);
    const names = workbook.getWorksheets().getNames();
    const namesCount = names.getCount();
    for (let i = 0; i < namesCount; i++) 
    {
        const namedRange = names.get(i);
        const referredAreas = namedRange.getReferredAreas(true);
        if (referredAreas) 
        {
            referredAreas.forEach(referredArea => {
                // Print the data in Referred Area
                console.log("IsExternalLink: " + referredArea.isExternalLink());
                console.log("IsArea: " + referredArea.isArea());
                console.log("SheetName: " + referredArea.getSheetName());
                console.log("ExternalFileName: " + referredArea.getExternalFileName());
                console.log("StartColumn: " + referredArea.getStartColumn());
                console.log("StartRow: " + referredArea.getStartRow());
                console.log("EndColumn: " + referredArea.getEndColumn());
                console.log("EndRow: " + referredArea.getEndRow());
            });
        }
    }
}
catch (e) 
{
    console.error(e);
}