You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.
Click the button below to launch CFFiddle.
To copy the project in your workspace in CFFiddle, follow the steps below:
- Log in with your Gmail or Facebook credentials.
- Navigate to the project in the left pane.
- Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
- Give the project a suitable name and click Save.
Description
Gets the property of an Excel spreadsheet object.
Returns
Returns a spreadsheet property that can be one of the following:
- AUTHOR
- CATEGORY
- COMMENTS
- CREATIONDATE
- LASTEDITED
- LASTAUTHOR
- LASTSAVED
- KEYWORDS
- MANAGER
- COMPANY
- SUBJECT
- TITLE
- SHEETS
- SHEETNAMES
- SPREADSHEETTYPES
Category
Microsoft Office Integration
Function syntax
SpreadsheetInfo(spreadsheetobj) |
See also
SpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow,
SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows
History
ColdFusion 9: Added the function.
Parameters
Parameter |
Description |
|---|---|
spreadsheetobj |
The Excel spreadsheet object from which to get the value. |
Usage
This function is supported by Microsoft Office Excel 2007 and Microsoft Office 2003.
Example
| <cfspreadsheet action="read" src="#dirname#SingleSheet.xls" name="SpreadsheetObj" > <cfset info = SpreadSheetInfo(SpreadsheetObj)> <cfoutput> AUTHOR : #info.author#<br> </cfoutput> <cfoutput> Creation Date : #info.creationdate#<br> </cfoutput> <cfoutput> LAST AUTHOR : #info.lastauthor#<br> </cfoutput> <cfoutput> SHEETS : #info.sheets#<br> </cfoutput> <cfoutput> SPREADSHEETTYPE : #info.SPREADSHEETTYPE#<br> </cfoutput> <cfoutput>SUBJECT : #info.SUBJECT#<br></cfoutput> <cfoutput>TITLE : #info.TITLE#<br></cfoutput> |
Sign in to your account