Whatever message this page gives is out now! Go check it out!
spreadsheetGetCellHyperlink
Last update:
May 18, 2026
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>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
