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) |
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. |
property_struct |
The following properties of the spreadsheet can be modified or set:
|
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"> |
