SpreadsheetGetCellValue

Description

Gets the Value for an Excel spreadsheet object cell.

Returns

A string containing the cell value.

Category

Microsoft Office Integration

Function syntax

SpreadsheetGetCellValue(spreadsheetObj, row, column)

See also

SpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellFormula, SpreadsheetSetCellValue

History

ColdFusion 9: Added the function.

Parameters

Parameter

Description

spreadsheetObj

The Excel spreadsheet object from which to get the value.

row

The row number of the cell from which to get the formula.

column

The column number of the cell from which to get the formula.

Example

The following lines create an Excel spreadsheet object, set the value of the cell at row 3, column 5 - 365, gets the value and displays it:

<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>