Skip to main content

Sheet Management

APIDescriptionExample
Workbook.WorksheetsProperty that returns the sheet management objectlet workbook = instance.Application.ActiveWorkbook;

let worksheets = workbook.Worksheets;
Worksheets.CountProperty that returns the number of sheets in the workbooklet workbook = instance.Application.ActiveWorkbook;
let worksheets = workbook.Worksheets;

console.log(worksheets.Count);
Worksheets.ItemFunction that returns a sheet object at a specific index within the workbooklet workbook = instance.Application.ActiveWorkbook;
let worksheets = workbook.Worksheets;

let worksheet1 = worksheets.Item(1); // Number-based
let worksheet2 = worksheets.Item("Sheet 1"); // Sheet name-based
Worksheets.AddFunction that adds a sheet within the workbooklet workbook = instance.Application.ActiveWorkbook;
let worksheets = workbook.Worksheets;

worksheets.Add({
Before: workbook.ActiveSheet
});
Worksheets.SelectFunction that selects all sheets within the workbooklet workbook = instance.Application.ActiveWorkbook;
let worksheets = workbook.Worksheets;

worksheets.Select();

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