Integrated Document Management
| API | Description | Example |
|---|---|---|
| Application.Workbooks | Property that returns the integrated document management object | let application = instance.Application; let workbooks = application.Workbooks; |
| Workbooks.Count | Property that returns the number of open workbooks | let workbooks = instance.Application.Workbooks; console.log(workbooks.Count); |
| Workbooks.Item | Function that returns a workbook object at a specific index | let workbooks = instance.Application.Workbooks; let workbook1 = workbooks.Item(1); // Number-based let workbook2 = workbooks.Item("Example.xlsx"); // Workbook name-based |
| Workbooks.Add | Function that adds a new workbook | let workbooks = instance.Application.Workbooks; let workbook = workbooks.Add(); |
| Workbooks.Close | Function that closes all workbooks | let workbooks = instance.Application.Workbooks; workbooks.Close(); |
| Workbooks.Open | Function that opens a workbook | let workbooks = instance.Application.Workbooks; workbooks.Open("/hnc/File/Example.xlsx"); |
Related Features
Spreadsheet Basic Functions , Engine Global Management , Integrated Document , Sheet Management , Sheet , Range , Area , Engine Object Common