spreadsheetInfo

Returns a struct of properties of a spreadsheet, such as the author, sheet names and creation date. CF 2025+ also returns a visibility struct showing whether each sheet is visible, hidden or very hidden.

spreadsheetInfo(spreadsheet) → returns struct

Argument Reference

spreadsheet variableName
Required

No Help Available

Examples
Sample code invoking the spreadsheetInfo function

Here we have simple example about spreadsheetinfo function. It displays the detail of read sreadsheet like sheet name,last edited,creation date etc..

<cfspreadsheet action="read" src="#expandPath("./reports.xls")#" name="SpreadsheetObj" >
<cfset spreadsheetInfo=spreadsheetInfo(SpreadsheetObj)>
<cfdump var="#spreadsheetInfo#" />

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub