ColdFusion 9.0 Resources |
SpreadsheetSetCellFormulaSee alsoSpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellValue Parameters
ExampleThe following line sets the formula for the cell at row 2 column 11 to be the sum of the cells in the column’s rows 1 through 12. The following example sets a cell formula, and gets the cell formula and value. <cfscript> //Create a new Excel spreadsheet object. theSheet=SpreadsheetNew(); //Set the values of column 3 rows 1-10 to the row number. for (i=1; i<= 10; i=i+1) SpreadsheetSetCellValue(theSheet,i,i,3); //Set the fomula for the cell in row 11 column 3 to be the sum of //Columns 1-10. SpreadsheetSetCellFormula(theSheet,"SUM(C1:C10)",11,3); //Get the formula from the Excel spreadsheet object. theValue=SpreadsheetGetCellFormula(theSheet,11,3); //Get the value of row 11 column 5 from the Excel spreadsheet object. theValue=SpreadsheetGetCellValue(theSheet,11,3); </cfscript> <cfoutput> Row 11, Column 3 value: #SpreadsheetGetCellValue(theSheet,11,3)#<br /> Row 11, Column 3 formula: #SpreadsheetGetCellFormula(theSheet,11,3)#<br /> </cfoutput> |