getCellAddress - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns the cell reference address as an alphanumeric string, e.g. A1 or DD203

getCellAddress( workbook, row, column );

Required arguments

  • workbook spreadsheet object
  • row numeric
  • column numeric

Chainable? Yes but ends the chain.

Note

  • An error will be thrown if the cell doesn't exist

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
// create a cell A1
spreadsheet.setCellValue( workbook, "This is cell A1", 1, 1 );
cellAddress = spreadsheet.getCellAddress( workbook, 1, 1 ); //A1