SpreadsheetAddInfo

Description

Sets document properties for a new spreadsheet or modifies properties for an existing spreadsheet.

Returns

This function does not return a value.

Category

Microsoft Office Integration

Function syntax

SpreadsheetAddInfo(spreadsheetobj, property_struct)

History

ColdFusion 9: Added the function.

Parameters

Parameter

Description

spreadsheetobj

The Excel spreadsheet object from which to get the value.

property_struct

The following properties of the spreadsheet can be modified or set:

  • AUTHOR

  • CATEGORY

  • LASTAUTHOR

  • COMMENTS

  • KEYWORDS

  • MANAGER

  • COMPANY

  • SUBJECT

  • TITLE

Usage

This function is supported by Microsoft Office Excel 2007 (.xlsx) and Microsoft Office 2003 (.xls).

Example

<cfspreadsheet action="read" src="#filename#" name="a"  > 
<cfset info = StructNew()> 
<cfset info.title="Title"> 
<cfset info.category="Category test"> 
<cfset info.author="ABC"> 
<cfset info.comments="Comments for this file"> 
<cfset spreadsheetaddInfo(a,info)> 
<cfspreadsheet action="write" filename="#dirname#SingleSheet.xls" name=a overwrite="yes">