getActiveCell - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns a struct containing the row and column of the currently active cell.

getActiveCell( workbook );

Required arguments

• workbook spreadsheet object

Chainable? Yes but ends the chain.

Return value keys

The method returns a struct with the keys row and column.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.newXlsx();
spreadsheet
  .addRow( workbook, [ "a", "b" ] )
  .setActiveCell( workbook, 1, 2 );
result = spreadsheet.getActiveCell( workbook );// returns { row: 1, column: 2 }