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)

spreadsheetGetCellHyperlink(spreadsheetObject,row,column)

Example

SELECT * FROM ART

</cfquery>

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>

<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>

<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?