Skip to main content

Sheet

APIDescriptionExample
Workbook.ActiveSheetProperty that returns the active sheet object within the integrated documentlet workbook = instance.Application.ActiveWorkbook;

let worksheet = workbook.ActiveSheet;
Worksheet.CellsProperty that returns a range object that manages all cells within the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

let cells = worksheet.Cells;
Worksheet.ColumnsProperty that returns a range object that manages columns within the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

let columns = worksheet.Columns;
Worksheet.IndexProperty that returns the sheet index within the workbooklet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

console.log(worksheet.Index);
Worksheet.NameProperty that returns the name of the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

console.log(worksheet.Name);
Worksheet.NextProperty that returns the next sheet objectlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

let nextSheet = worksheet.Next;
Worksheet.PreviousProperty that returns the previous sheet objectlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

let previousSheet = worksheet.Previous;
Worksheet.RowsProperty that returns a range object that manages rows within the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

let rows = worksheet.Rows;
Worksheet.UsedRangeProperty that returns the range object containing data within the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

let range = worksheet.UsedRange;
Worksheet.VisibleProperty that returns or changes the visibility state of the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

console.log(worksheet.Visible);
worksheet.Visible = instance.Enums.XlSheetVisibility.xlSheetHidden;
Worksheet.ActivateFunction that activates the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

worksheet.Activate();
Worksheet.CalculateFunction that recalculates changed formulas within the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

worksheet.Calculate();
Worksheet.CopyFunction that copies the sheet to a specific locationlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.Worksheets.Item(1);

worksheet.Copy(); // Duplicate by creating a new workbook
worksheet.Copy({
After: workbook.ActiveSheet
}); // Duplicate within the current workbook
Worksheet.DeleteFunction that deletes the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

worksheet.Delete();
Worksheet.MoveFunction that moves the sheet to a specific locationlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.Worksheets.Item(1);

worksheet.Move(); // Move by creating a new workbook
worksheet.Move({
After: workbook.ActiveSheet
}); // Move within the current workbook
Worksheet.SelectFunction that selects the sheetlet workbook = instance.Application.ActiveWorkbook;
let worksheet = workbook.ActiveSheet;

worksheet.Select();

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