SpreadsheetSetCellHyperlink

Sets a hyperlink on a cell in a spreadsheet.

Method Signature

SpreadsheetSetCellHyperlink(spreadsheetObj=[any], row=[any], column=[any], hyperlink=[any], label=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
row	NUMERIC	true	The row number (1-based).
column	NUMERIC	true	The column number (1-based).
hyperlink	STRING	true	The hyperlink URL (e.g., "http://example.com", "mailto:[email protected]").
label	STRING	false	The optional display label for the hyperlink. If not provided, the URL is displayed.

Examples

Add a hyperlink to a cell:

// Add URL to cell
var spreadsheet = SpreadsheetNew();
SpreadsheetSetCellValue( spreadsheet, 1, 1, "Visit Website" );
SpreadsheetSetCellHyperlink( spreadsheet, 1, 1, "https://example.com" );

Create resource links:

// Add multiple links
var spreadsheet = SpreadsheetNew();
SpreadsheetSetCellValue( spreadsheet, 1, 1, "Google" );
SpreadsheetSetCellHyperlink( spreadsheet, 1, 1, "https://google.com" );

SpreadsheetSetCellValue( spreadsheet, 2, 1, "GitHub" );
SpreadsheetSetCellHyperlink( spreadsheet, 2, 1, "https://github.com" );

Related

• SpreadsheetGetCellHyperlink() - Get hyperlink

• SpreadsheetSetCellValue() - Set cell value