Skip to main content

SetActive

Makes the current sheet active.

Syntax​

expression.SetActive();

expression - A variable that represents a ApiWorksheet class.

Parameters​

This method doesn't have any parameters.

Returns​

This method doesn't return any data.

Example​

This example makes the sheet active.

Api.AddSheet("New_sheet");
var oSheet = Api.GetSheet("New_sheet");
oSheet.SetActive();
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A1").SetValue("The current sheet is active.");