HyperlinkCollectionAdd Method (Int32, Int32, Int32, Int32, String)

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

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.1.0.0 (20.1)
Syntax
public int Add(
	int firstRow,
	int firstColumn,
	int totalRows,
	int totalColumns,
	string address
)

Parameters

firstRow
Type: SystemInt32
First row of the hyperlink range.
firstColumn
Type: SystemInt32
First column of the hyperlink range.
totalRows
Type: SystemInt32
Number of rows in this hyperlink range.
totalColumns
Type: SystemInt32
Number of columns of this hyperlink range.
address
Type: SystemString
Address of the hyperlink.

Return Value

Type: Int32
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