SpreadsheetInfo

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>