setCellFormula - cfsimplicity/spreadsheet-cfml GitHub Wiki

Sets the formula for a cell.

setCellFormula( workbook, formula, row, column )

Required arguments

  • workbook spreadsheet object
  • formula string
  • row numeric
  • column numeric

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.addColumn( workbook, "1, 1" );
spreadsheet.setCellFormula( workbook, "SUM(A1:A2)", 3, 1 );