ColdFusion 9.0 Resources |
SpreadsheetInfoDescriptionGets the property of an Excel spreadsheet object. ReturnsReturns a spreadsheet property that can be one of the following:
CategoryMicrosoft Office Integration Function syntaxSpreadsheetInfo(spreadsheetobj) See alsoSpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows HistoryColdFusion 9: Added the function. Parameters
UsageThis 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> |