Skip to main content

GetActiveCell

Returns an object that represents an active cell.

Syntax​

expression.GetActiveCell();

expression - A variable that represents an ApiWorksheet class.

Parameters​

This method doesn't have any parameters.

Returns​

ApiRange

Example​

Read the currently selected cell and write a value into it in a spreadsheet.

// How do I find out which cell is active and put content into it in a spreadsheet?

// Target the focused cell and populate it with custom text.

let worksheet = Api.GetActiveSheet();
let activeCell = worksheet.GetActiveCell();
activeCell.SetValue("This sample text was placed in an active cell.");