Add

Add(int, int, int, int, string)

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

public int Add(int firstRow, int firstColumn, int totalRows, int totalColumns, string address)
Parameter Type Description
firstRow Int32 First row of the hyperlink range.
firstColumn Int32 First column of the hyperlink range.
totalRows Int32 Number of rows in this hyperlink range.
totalColumns Int32 Number of columns of this hyperlink range.
address String Address of the hyperlink.

Return Value

Hyperlink object index.

Examples

[C#]

Worksheet worksheet = excel.Worksheets[0];
worksheet.Hyperlinks.Add("A4", 1, 1, "http://www.aspose.com");
worksheet.Hyperlinks.Add("A5", 1, 1, "c:\\book1.xls");

[Visual Basic]

Dim worksheet as Worksheet = excel.Worksheets(0)
worksheet.Hyperlinks.Add("A4", 1, 1, "http://www.aspose.com")
worksheet.Hyperlinks.Add("A5", 1, 1, "c:\\book1.xls")

See Also


Add(string, int, int, string)

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

public int Add(string cellName, int totalRows, int totalColumns, string address)
Parameter Type Description
cellName String Cell name.
totalRows Int32 Number of rows in this hyperlink range.
totalColumns Int32 Number of columns of this hyperlink range.
address String Address of the hyperlink.

Return Value

GridHyperlink object index.

See Also


Add(string, string)

Adds a hyperlink to a specified cell .

public int Add(string cellName, string address)
Parameter Type Description
cellName String Cell name.
address String Address of the hyperlink.

Return Value

GridHyperlink object index.

See Also


Add(string, string, string, string, string)

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

public int Add(string startCellName, string endCellName, string address, string textToDisplay, 
    string screenTip)
Parameter 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.

Return Value

GridHyperlink object index.

See Also