Interface PivotTableTarget

What the New PivotTable dialog asks of the workbook while it is open.

interface PivotTableTarget {
checkLocation(location: ICellRanges): string | null;
validateName(name: string, location: ICellRanges | null): void;
}

Index

Methods

checkLocation validateName

Methods

checkLocation

checkLocation(location: ICellRanges): string | null
Why a new table cannot go at location, as a message key; null when it can.
Parameters
- location: ICellRanges
Returns string | null

validateName

validateName(name: string, location: ICellRanges | null): void
Throws for a name a new table cannot take on the sheet location is on.
Parameters
- name: string
- location: ICellRanges | null
Returns void