spreadsheetGetCellHyperlink

Description

Retrieves the information about a hyperlink applied on a specific cell.

Returns

A struct, which contains information related to hyperlink for a specified cell. Depending upon the type of cell, it can get values like address, label, type, etc.

History

ColdFusion (2025 release): Added the function.

Syntax

spreadsheetGetCellHyperlink(spreadsheetObject,row,column)

Example

<cfquery name="art" datasource="cfartgallery">
    SELECT * FROM ART
</cfquery>
<cfscript>
    theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls";
    // create a spreadsheet object
    theSheet=spreadsheetNew("SampleData")
    // add rows from query
    spreadsheetAddRows(theSheet,art)
    // hyperlink struct
    hStruct={
        row:1,
        column:4,
        address: "https://www.adobe.com",
        type:"URL"
    }
    // set hyperlink on cell 11,4
    spreadsheetSetCellHyperlink(theSheet,hStruct)
    spreadsheetWrite(theSheet,theFile,"yes")
    getHyperLink=spreadsheetGetCellHyperlink(theSheet,1,4)
    //getHyperLink=spreadsheetGetCellHyperlink(theSheet,hStruct)
    writeDump(getHyperLink)
</cfscript>

Get help faster and easier

New user?