Workbook resource type

Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc.

Methods

Method Return Type Description
List names NamedItem collection Get a NamedItem object collection.
Create Table Table Create a new Table by posting to the tables collection.
List tables Table collection Get a Table object collection.
List worksheets Worksheet collection Get a Worksheet object collection.

Properties

None

Relationships

Relationship Type Description
names NamedItem collection Represents a collection of workbook scoped named items (named ranges and constants). Read-only.
tables Table collection Represents a collection of tables associated with the workbook. Read-only.
worksheets Worksheet collection Represents a collection of worksheets associated with the workbook. Read-only.