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 Optional 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 Optional 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 Optional 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.

Parameter

Name Type Optional Description

index

Number

 

The zero based index of the element.