Type Alias PivotCacheWorksheetSourceRange

A worksheet range source, identified by a cell range and sheet name.

type PivotCacheWorksheetSourceRange = {
    ref: CellRange;
    sheet?: string;
    type: "range";
}

Index

Properties

ref sheet? type

Properties

ref

The A1-style range reference to the source data, including headers.

`Optional`sheet

sheet?: string

The name of the sheet containing the source data.

type

type: "range"

Type discriminator for a worksheet range source.