Namespace IWorksheet

An IWorksheet represents a collection of elements (such as ranges, tables, etc) contained within and visualized through a view.

This interface provides methods for accessing its elements and event handling.

Most interactions with a sheet are done using either a range or ranges.

Remarks

While a sheet can be used stand-alone it is typically used within the context of a workbook.

Key Methods

IWorksheet.getRange - For interacting with cells and Scalar | values and formatting.
IWorksheet.getTables - For managing tables.
IWorksheet.getView - For non-data related properties such as selection or frozen headers.
IWorkbook - For working with collections of ISheets.

See

Interface

Implementation

Sheet

Interfaces

ChangeEvent
ConstructorOptions
ContainerOptions
EntireSize
Events
IListeners
JSON
LegacyDrawingJSON
PropertiesJSON
ScrollToOptions
Shift
SyncScroll
ToJSONOptions

Type Aliases

ChangeEventKey
RangeAddress
RangesAddress
ShiftKind