ColdFusion 9.0 Resources |
SpreadsheetGetCellFormulaReturnsIf the parameters include the row and column: a string containing the formula. If the function has the spreadsheetObj parameter, an array containing structures for each formula. See alsoSpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellFormula, SpreadsheetSetCellValue Parameters
UsageIf you specify only the spreadsheetObj parameter, the function returns an array of the structures with the following contents. The array has one entry for each cell that contains a formula.
ExampleThe 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 formula 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> |