@sheetwrite/corefunction
Validate one canonical table against sheet bounds and workbook-global identities.
- Package
@sheetwrite/core- Source
packages/core/src/workbook-table.ts#L133
Declaration
function validWorkbookTable( table: WorkbookTableinterface WorkbookTable {
id: WorkbookTableId;
name: string;
range: Range;
columns: WorkbookTableColumn[];
headerRow: boolean;
totalsRow: boolean;
style?: WorkbookTableStyle;
unsupportedFeatures?: WorkbookTableUnsupportedFeature[];
}interface WorkbookTable {
id: WorkbookTableId;
name: string;
range: Range;
columns: WorkbookTableColumn[];
headerRow: boolean;
totalsRow: boolean;
style?: WorkbookTableStyle;
unsupportedFeatures?: WorkbookTableUnsupportedFeature[];
}interface WorkbookTable {
id: WorkbookTableId;
name: string;
range: Range;
columns: WorkbookTableColumn[];
headerRow: boolean;
totalsRow: boolean;
style?: WorkbookTableStyle;
unsupportedFeatures?: WorkbookTableUnsupportedFeature[];
}Serializable canonical workbook table. Its range includes header/totals rows.API reference →, sheet: Sheetinterface Sheet {
id: SheetId;
name: string;
visibility?: SheetVisibility;
columns: Column[];
rowCount: number;
rowHeights?: Map<number, number>;
hiddenRows?: Set<number>;
rowGroups?: RowGroup[];
conditionalFormats?: ConditionalFormatRule[];
hyperlinks?: CellHyperlink[];
validationRules?: DataValidationRule[];
protectedRanges?: ProtectedRange[];
notes?: CellNote[];
sortKeys?: SortKey[];
// … 6 more lines — see the API reference
}interface Sheet {
id: SheetId;
name: string;
visibility?: SheetVisibility;
columns: Column[];
rowCount: number;
rowHeights?: Map<number, number>;
hiddenRows?: Set<number>;
rowGroups?: RowGroup[];
conditionalFormats?: ConditionalFormatRule[];
hyperlinks?: CellHyperlink[];
validationRules?: DataValidationRule[];
protectedRanges?: ProtectedRange[];
notes?: CellNote[];
sortKeys?: SortKey[];
// … 6 more lines — see the API reference
}interface Sheet {
id: SheetId;
name: string;
visibility?: SheetVisibility;
columns: Column[];
rowCount: number;
rowHeights?: Map<
number,
number
>;
hiddenRows?: Set<number>;
rowGroups?: RowGroup[];
conditionalFormats?: ConditionalFormatRule[];
hyperlinks?: CellHyperlink[];
validationRules?: DataValidationRule[];
protectedRanges?: ProtectedRange[];
notes?: CellNote[];
sortKeys?: SortKey[];
filters?: Array<
// … 10 more lines — see the API reference
}Workbook sheet schema used when creating a live grid.API reference →, existing: readonly WorkbookTableinterface WorkbookTable {
id: WorkbookTableId;
name: string;
range: Range;
columns: WorkbookTableColumn[];
headerRow: boolean;
totalsRow: boolean;
style?: WorkbookTableStyle;
unsupportedFeatures?: WorkbookTableUnsupportedFeature[];
}interface WorkbookTable {
id: WorkbookTableId;
name: string;
range: Range;
columns: WorkbookTableColumn[];
headerRow: boolean;
totalsRow: boolean;
style?: WorkbookTableStyle;
unsupportedFeatures?: WorkbookTableUnsupportedFeature[];
}interface WorkbookTable {
id: WorkbookTableId;
name: string;
range: Range;
columns: WorkbookTableColumn[];
headerRow: boolean;
totalsRow: boolean;
style?: WorkbookTableStyle;
unsupportedFeatures?: WorkbookTableUnsupportedFeature[];
}Serializable canonical workbook table. Its range includes header/totals rows.API reference →[], limits?: Readonly<WorkbookTableResourceLimitsinterface WorkbookTableResourceLimits {
maxTables: number;
maxColumnsPerTable: number;
maxNameLength: number;
maxIdLength: number;
maxStyleNameLength: number;
maxUnsupportedFeaturesPerTable: number;
}interface WorkbookTableResourceLimits {
maxTables: number;
maxColumnsPerTable: number;
maxNameLength: number;
maxIdLength: number;
maxStyleNameLength: number;
maxUnsupportedFeaturesPerTable: number;
}interface WorkbookTableResourceLimits {
maxTables: number;
maxColumnsPerTable: number;
maxNameLength: number;
maxIdLength: number;
maxStyleNameLength: number;
maxUnsupportedFeaturesPerTable: number;
}Resource ceilings for canonical workbook-table metadata and identifiers.API reference →>,): boolean