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