Skip to main content

Integrated Document Management

APIDescriptionExample
Application.WorkbooksProperty that returns the integrated document management objectlet application = instance.Application;

let workbooks = application.Workbooks;
Workbooks.CountProperty that returns the number of open workbookslet workbooks = instance.Application.Workbooks;

console.log(workbooks.Count);
Workbooks.ItemFunction that returns a workbook object at a specific indexlet workbooks = instance.Application.Workbooks;

let workbook1 = workbooks.Item(1); // Number-based
let workbook2 = workbooks.Item("Example.xlsx"); // Workbook name-based
Workbooks.AddFunction that adds a new workbooklet workbooks = instance.Application.Workbooks;

let workbook = workbooks.Add();
Workbooks.CloseFunction that closes all workbookslet workbooks = instance.Application.Workbooks;

workbooks.Close();
Workbooks.OpenFunction that opens a workbooklet workbooks = instance.Application.Workbooks;

workbooks.Open("/hnc/File/Example.xlsx");

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