Returns spreadsheet property

spreadsheetInfo(spreadsheetObj) → returns struct

spreadsheetInfo Argument Reference

spreadsheetObj variableName

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#" />

Fork me on GitHub