SpreadsheetSetCellValue

Description

Specifies the value of an Excel spreadsheet object cell.

Category

Microsoft Office Integration

Function syntax

SpreadsheetSetCellValue(spreadsheetObj, value, row, column)

See also

SpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellFormula

History

ColdFusion 9: Added the function.

Parameters

Parameter

Description

spreadsheetObj

The Excel spreadsheet object to which to add the comment.

value

A string containing the cell value.

row

The row number of the cell to which to set the value.

column

The column number of the cell to which to set the value.

Example

The following lines create an Excel spreadsheet object, set the value of the cell at row 3, column 5 to 365, and get the value:

<cfscript> 
    //Create a new Excel spreadsheet object. 
    theSheet=SpreadsheetNew(); 
    //Set the value of the cell at row 3 column 5. 
    SpreadsheetSetCellValue(theSheet,365,3,5); 
    //Get the value from the Excel spreadsheet object. 
    theValue=SpreadsheetGetCellValue(theSheet,3,5); 
    WriteOutput("The value of column 5 row 3 is: " & theValue); 
</cfscript>