ColdFusion 9.0 Resources |
SpreadsheetAddInfoDescriptionSets document properties for a new spreadsheet or modifies properties for an existing spreadsheet. ReturnsThis function does not return a value. CategoryMicrosoft Office Integration Function syntaxSpreadsheetAddInfo(spreadsheetobj, property_struct) See alsoSpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows HistoryColdFusion 9: Added the function. Parameters
UsageThis 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"> |