ColdFusion 9.0 Resources |
SpreadsheetGetCellValueSee alsoSpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellFormula, SpreadsheetSetCellValue Parameters
ExampleThe 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> |