Skip to main content

Engine Global Management

APIDescriptionExample
Application.ActiveCellProperty that returns a range object corresponding to the selected cell within the active sheet of the active integrated document in the engine global
cf) When a range is active, it is specified as the top-left cell		let application = instance.Application;

let activeCell = application.ActiveCell;
Application.ActiveChartProperty that returns the selected chart object within the active sheet of the active workbook in the engine globallet application = instance.Application;

let activeChart = application.ActiveChart;
Application.ActiveSheetProperty that returns the active sheet object of the active workbook in the engine globallet application = instance.Application;

let activeSheet = application.ActiveSheet;
Application.ActiveWorkbookProperty that returns the active workbook object in the engine globallet application = instance.Application;

let activeWorkbook = application.ActiveWorkbook;
Application.CalculationProperty that returns or changes the global calculation methodlet application = instance.Application;

console.log(application.Calculation);
application.Calculation = instance.Enums.XlCalculation.xlCalculationManual;
Application.CellsProperty that returns a range object that manages all cells within the active sheet of the active workbook in the engine globallet application = instance.Application;

let cells = application.Cells;
Application.ColumnsProperty that returns a range object that manages columns within the active sheet of the active workbook in the engine globallet application = instance.Application;

let columns = application.Columns;
Application.DefaultSaveFormatProperty that returns or changes the default save file format globallylet application = instance.Application;

console.log(application.DefaultSaveFormat);
application.DefaultSaveFormat = instance.Enums.XlFileFormat.xlCSV;
Application.DisplayAlertsProperty that returns or changes whether to display alert messages when necessarylet application = instance.Application;

console.log(application.DisplayAlerts);
application.DisplayAlerts = false;
Application.RowsProperty that returns a range object that manages rows within the active sheet of the active workbook in the engine globallet application = instance.Application;

let rows = application.Rows;
Application.SelectionProperty that returns the selected object within the active sheet of the active workbook in the engine global
cf) Objects such as range, shape, and chart		let application = instance.Application;

let selection = application.Selection;

switch (selection.ActualType) {
case "Range": {
break;
}

default: {
break;
}
}
Application.SheetsInNewWorkbookProperty that returns or changes the default number of sheets when creating a new documentlet application = instance.Application;

console.log(application.SheetsInNewWorkbook);
application.SheetsInNewWorkbook = 1;
Application.WorksheetsProperty that returns the sheet manager object of the active workbook in the engine globallet application = instance.Application;

let worksheets = application.Worksheets;
Application.RangeFunction that specifies a specific range of the active sheet of the active workbook in the engine globallet application = instance.Application;

let range = application.Range("A1");
Application.CalculateFunction that recalculates changed formulas in all open workbookslet application = instance.Application;

application.Calculate();
Application.CalculateFullFunction that recalculates all formulas in all open workbookslet application = instance.Application;

application.CalculateFull();
Application.CalculateFullRebuildFunction that recalculates all formulas including dependencies in all open workbookslet application = instance.Application;

application.CalculateFullRebuild();
Application.CentimetersToPointsFunction that converts a numeric value in centimeters (cm) to points (pt)let application = instance.Application;

console.log(application.CentimetersToPoints(10));
Application.GotoFunction that selects a specific range and activates the workbook and sheet containing that rangelet application = instance.Application;
let target = application.Worksheets.Item(1).Range("A1:B2");

application.Goto(target)
Application.InchesToPointsFunction that converts a numeric value in inches to points (pt)let application = instance.Application;

console.log(application.InchesToPoints(10));
Application.IntersectFunction that specifies the intersection range from two or more rangeslet application = instance.Application;

let b2c3Range = application.Intersect(application.Range("A1:C3"), application.Range("B2:D4"));
Application.UnionFunction that specifies the union range of two or more rangeslet application = instance.Application;

let a1b2Andc3d4Range = application.Union(application.Range("A1:B2"), application.Range("C3:D4"));

Spreadsheet Basic Functions , Integrated Document Management , Integrated Document , Sheet Management , Sheet , Range , Area , Engine Object Common