Class: HyperlinkCollection - Aspose.Cells for Node.js via Java

Methods

add(firstRow, firstColumn, totalRows, totalColumns, address) → Number

Adds a hyperlink to a specified cell or a range of cells.

Example

var excel = new aspose.cells.Workbook();
var worksheet = excel.getWorksheets().get(0);
worksheet.getHyperlinks().add("A4", 1, 1, "http://www.aspose.com");
worksheet.getHyperlinks().add("A5", 1, 1, "c:\\book1.xls");

Parameters

Name	Type	Description
firstRow	Number	First row of the hyperlink range.
firstColumn	Number	First column of the hyperlink range.
totalRows	Number	Number of rows in this hyperlink range.
totalColumns	Number	Number of columns of this hyperlink range.
address	String	Address of the hyperlink.

Returns: Number Hyperlink object index.

add(cellName, totalRows, totalColumns, address) → Number

Adds a hyperlink to a specified cell or a range of cells.

Parameters

Name	Type	Description
cellName	String	Cell name.
totalRows	Number	Number of rows in this hyperlink range.
totalColumns	Number	Number of columns of this hyperlink range.
address	String	Address of the hyperlink.

Returns: Number Hyperlink object index.

add(startCellName, endCellName, address, textToDisplay, screenTip) → Number

Adds a hyperlink to a specified cell or a range of cells.

Parameters

Name	Type	Description
startCellName	String	The top-left cell of the range.
endCellName	String	The bottom-right cell of the range.
address	String	Address of the hyperlink.
textToDisplay	String	The text to be displayed for the specified hyperlink.
screenTip	String	The screenTip text for the specified hyperlink.

Returns: Number Hyperlink object index.

add()

Reserved for internal use.

clear()

Clears all hyperlinks.

contains()

Reserved for internal use.

get(index) → Hyperlink

Gets the Hyperlink element at the specified index.

Parameter

Name	Type	Optional	Description
index	Number		The zero based index of the element.

Returns: Hyperlink The element at the specified index.

get()

Reserved for internal use.

getCount()

indexOf()

Reserved for internal use.

iterator()

removeAt(index)

Remove the hyperlink at the specified index in this collection.

Parameter

Name	Type	Optional	Description
index	Number		The zero based index of the element.