spreadsheetSetActiveCell

Sets the active cell of the active sheet in a spreadsheet workbook. Rows and columns are 1-based (row 1, column 1 = cell A1). The fluent member form is setActiveCell(row, column).

spreadsheetSetActiveCell(spreadsheetObj, row, column) → returns any

This function requires RustCFML.  Not supported on Lucee, Adobe ColdFusion, etc.
  1. CFDocs
  2. Functions
  3. All CFML Functions
  4. spreadsheetSetActiveCell
  5. RustCFML
  6. 0 Issue
  7. Edit
See Also:   spreadsheetSetActiveSheet   spreadsheetNew

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

row numeric
Required

1-based row index of the active cell.

column numeric
Required

1-based column index of the active cell.

Compatibility

RustCFML:

Not supported on wasm32.

Examples
Sample code invoking the spreadsheetSetActiveCell function

Make C4 the active cell of the active sheet.

wb = Spreadsheet("xlsx");
spreadsheetSetActiveCell(wb, 4, 3);

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub