Detect Hyperlink Type

Detect Hyperlink Type

An Excel file can have different types of hyperlinks like external, cell reference, file path, etc. Aspose.Cells for Node.js via C++ supports the feature to detect the type of hyperlink. The types of hyperlinks are represented by the TargetModeType Enumeration. The TargetModeType Enumeration has the following members.

• External: External link
• FilePath: Local and full path to files/folders.
• Email: Email
• CellReference: Link to cell or named range.

To check the type of hyperlink, the Hyperlink class provides a getLinkType() method with a return type of TargetModeType. The following code snippet demonstrates the use of the getLinkType() method by using this source excel file.

Source Code

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

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

const workbook = new AsposeCells.Workbook(sourceDir + "LinkTypes.xlsx");

// Get the first (default) worksheet
const worksheet = workbook.getWorksheets().get(0);

// Create a range A1:B7
const range = worksheet.getCells().createRange("A1", "A7");

// Get Hyperlinks in range
const hyperlinks = range.getHyperlinks();

hyperlinks.forEach(link => {
    console.log(link.getTextToDisplay() + ": " + link.getLinkType());
});

The following is the output generated by the code snippet given above.

Console Output

LinkTypes.xlsx: FilePath </br>
C:\Windows\System32\cmd.exe: FilePath </br>
C:\Program Files\Common Files: FilePath </br>
'Test Sheet'!B2: CellReference </br>
FullPathExample: CellReference </br>
https://products.aspose.com/cells/ : External </br>
mailto:[e-mail]?subject=TestLink: Email </br>