GrapeCity.Spreadsheet.IHyperlinks.Add

Add Method

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

Adds a hyperlink to the specified range.

Declaration

IHyperlink Add(int row, int column, string address, string subAddress = null, string screenTip = null, string display = null)

Function Add(row As Integer, column As Integer, address As String, Optional subAddress As String = Nothing, Optional screenTip As String = Nothing, Optional display As String = Nothing) As IHyperlink

Parameters

Type	Name	Description
int	row	The row for the hyperlink
int	column	The column for the hyperlink
string	address	The address of the hyperlink.
string	subAddress	The subaddress of the hyperlink.
string	screenTip	The screen tip to be displayed when the mouse pointer is paused over the hyperlink.
string	display	The text to be displayed for the hyperlink.

Returns

Type	Description
IHyperlink	A IHyperlink object that represents the new hyperlink.

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

Adds a hyperlink to the specified range.

Declaration

IHyperlink Add(int row, int column, int row2, int column2, string address, string subAddress = null, string screenTip = null, string display = null)

Function Add(row As Integer, column As Integer, row2 As Integer, column2 As Integer, address As String, Optional subAddress As String = Nothing, Optional screenTip As String = Nothing, Optional display As String = Nothing) As IHyperlink

Parameters

Type	Name	Description
int	row	The top row for the hyperlink
int	column	The left column for the hyperlink
int	row2	The bottom row for the hyperlink
int	column2	The right column for the hyperlink
string	address	The address of the hyperlink.
string	subAddress	The subaddress of the hyperlink.
string	screenTip	The screen tip to be displayed when the mouse pointer is paused over the hyperlink.
string	display	The text to be displayed for the hyperlink.

Returns

Type	Description
IHyperlink	A IHyperlink object that represents the new hyperlink.

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

Adds a hyperlink to the specified range.

Declaration

IHyperlink Add(string range, string address, string subAddress = null, string screenTip = null, string display = null)

Function Add(range As String, address As String, Optional subAddress As String = Nothing, Optional screenTip As String = Nothing, Optional display As String = Nothing) As IHyperlink

Parameters

Type	Name	Description
string	range	The range for the hyperlink
string	address	The address of the hyperlink.
string	subAddress	The subaddress of the hyperlink.
string	screenTip	The screen tip to be displayed when the mouse pointer is paused over the hyperlink.
string	display	The text to be displayed for the hyperlink.

Returns

Type	Description
IHyperlink	A IHyperlink object that represents the new hyperlink.

Add(IShape, string, string, string)

Adds a hyperlink to the specified range.

Declaration

IHyperlink Add(IShape shape, string address, string subAddress = null, string screenTip = null)

Function Add(shape As IShape, address As String, Optional subAddress As String = Nothing, Optional screenTip As String = Nothing) As IHyperlink

Parameters

Type	Name	Description
IShape	shape	The IShape object for the hyperlink
string	address	The address of the hyperlink.
string	subAddress	The subaddress of the hyperlink.
string	screenTip	The screen tip to be displayed when the mouse pointer is paused over the hyperlink.

Returns

Type	Description
IHyperlink	A IHyperlink object that represents the new hyperlink.

Add Method