SetCellHyperlink method: PSSpreadsheet class

Syntax

SetCellHyperlink(rownum, colnum, link)

Description

Use the SetCellHyperlink method to set a hyperlink for the specified cell in the active spreadsheet.

Parameters

Parameter Description

rownum

Specifies the row number for the cell.

colnum

Specifies the column number for the cell.

link

Specifies the hyperlink value to be set for the specified cell.

Returns

(Optional) A Boolean value: True if the method completes successfully, False otherwise.

Example

The following example sets the hyperlink value of the specified cell within the spreadsheet.

&rownum = 2;
&colnum = 2;
&link = "http://www.oracle.com";
&ssObject.SetCellHyperlink(&rownum, &colnum, &link);