WorkbookTablePatch | @sheetwrite/core

Mutable table fields accepted by the explicit update operation.

Package: @sheetwrite/core
Source: packages/core/src/types/table.ts#L55

Members 7

name

name?: string;

range

range?: Rangeinterface Range {
  sheet: SheetId;
  start: { row: number; col: number };
  end: { row: number; col: number };
}interface Range {
  sheet: SheetId;
  start: { row: number; col: number };
  end: { row: number; col: number };
}interface Range {
  sheet: SheetId;
  start: {
    row: number;
    col: number;
  };
  end: {
    row: number;
    col: number;
  };
}Inclusive rectangular cell range on a stable sheet ID.API reference →;

columns

columns?: WorkbookTableColumninterface WorkbookTableColumn {
  id: string;
  name: string;
  totalsRowLabel?: string;
}interface WorkbookTableColumn {
  id: string;
  name: string;
  totalsRowLabel?: string;
}interface WorkbookTableColumn {
  id: string;
  name: string;
  totalsRowLabel?: string;
}Stable identity and display metadata for one ordered table column.API reference →[];

headerRow

headerRow?: boolean;

totalsRow

totalsRow?: boolean;

style

style?: WorkbookTableStyleinterface WorkbookTableStyle {
  name?: string;
  showFirstColumn?: boolean;
  showLastColumn?: boolean;
  showRowStripes?: boolean;
  showColumnStripes?: boolean;
}interface WorkbookTableStyle {
  name?: string;
  showFirstColumn?: boolean;
  showLastColumn?: boolean;
  showRowStripes?: boolean;
  showColumnStripes?: boolean;
}interface WorkbookTableStyle {
  name?: string;
  showFirstColumn?: boolean;
  showLastColumn?: boolean;
  showRowStripes?: boolean;
  showColumnStripes?: boolean;
}Bounded native subset of ECMA-376 table style information.API reference → | null;

unsupportedFeatures

unsupportedFeatures?: WorkbookTableUnsupportedFeaturetype WorkbookTableUnsupportedFeature =
  | "auto-filter"
  | "sort-state"
  | "calculated-columns"
  | "totals-functions"
  | "query-table"
  | "external-data"
  | "extensions";type WorkbookTableUnsupportedFeature =
  | "auto-filter"
  | "sort-state"
  | "calculated-columns"
  | "totals-functions"
  | "query-table"
  | "external-data"
  | "extensions";type WorkbookTableUnsupportedFeature =
  | "auto-filter"
  | "sort-state"
  | "calculated-columns"
  | "totals-functions"
  | "query-table"
  | "external-data"
  | "extensions";OOXML table features deliberately retained as explicit loss metadata rather than silently flattened into an ordinary range.API reference →[];

Declaration

View full TypeScript declaration

export interface WorkbookTablePatch {
  name?: string;
  range?: Rangeinterface Range {
  sheet: SheetId;
  start: { row: number; col: number };
  end: { row: number; col: number };
}interface Range {
  sheet: SheetId;
  start: { row: number; col: number };
  end: { row: number; col: number };
}interface Range {
  sheet: SheetId;
  start: {
    row: number;
    col: number;
  };
  end: {
    row: number;
    col: number;
  };
}Inclusive rectangular cell range on a stable sheet ID.API reference →;
  columns?: WorkbookTableColumninterface WorkbookTableColumn {
  id: string;
  name: string;
  totalsRowLabel?: string;
}interface WorkbookTableColumn {
  id: string;
  name: string;
  totalsRowLabel?: string;
}interface WorkbookTableColumn {
  id: string;
  name: string;
  totalsRowLabel?: string;
}Stable identity and display metadata for one ordered table column.API reference →[];
  headerRow?: boolean;
  totalsRow?: boolean;
  style?: WorkbookTableStyleinterface WorkbookTableStyle {
  name?: string;
  showFirstColumn?: boolean;
  showLastColumn?: boolean;
  showRowStripes?: boolean;
  showColumnStripes?: boolean;
}interface WorkbookTableStyle {
  name?: string;
  showFirstColumn?: boolean;
  showLastColumn?: boolean;
  showRowStripes?: boolean;
  showColumnStripes?: boolean;
}interface WorkbookTableStyle {
  name?: string;
  showFirstColumn?: boolean;
  showLastColumn?: boolean;
  showRowStripes?: boolean;
  showColumnStripes?: boolean;
}Bounded native subset of ECMA-376 table style information.API reference → | null;
  unsupportedFeatures?: WorkbookTableUnsupportedFeaturetype WorkbookTableUnsupportedFeature =
  | "auto-filter"
  | "sort-state"
  | "calculated-columns"
  | "totals-functions"
  | "query-table"
  | "external-data"
  | "extensions";type WorkbookTableUnsupportedFeature =
  | "auto-filter"
  | "sort-state"
  | "calculated-columns"
  | "totals-functions"
  | "query-table"
  | "external-data"
  | "extensions";type WorkbookTableUnsupportedFeature =
  | "auto-filter"
  | "sort-state"
  | "calculated-columns"
  | "totals-functions"
  | "query-table"
  | "external-data"
  | "extensions";OOXML table features deliberately retained as explicit loss metadata rather than silently flattened into an ordinary range.API reference →[];
}