Bounded OOXML table-rule metadata. Names are unprefixed SpreadsheetML element
names, not markup; the XLSX writer escapes text and attribute values. Keeping
the rule tree avoids flattening date groups, custom filters or sort options
into Sheetwrite's independently evaluated worksheet filters.
Members 5
name
attributesattributes : Record < string, string > ;
text
children
differentialStyle Style behind a color filter/sort rule; dxfId is regenerated on export.
Declaration
View full TypeScript declaration
export interface WorkbookTableXmlElement {
attributes : Record < string , string >;
children : WorkbookTableXmlElement [];
Referenced by
Workspace packages depending on @sheetwrite/core
@sheetwrite/benchdependency @sheetwrite/chartsdependency @sheetwrite/docs-startdependency @sheetwrite/reactdependency @sheetwrite/sveltedependency @sheetwrite/vuedependency @sheetwrite/xlsxdependency
Public exports naming WorkbookTableXmlElement
interface WorkbookTableXmlElement {
name: string;
attributes: Record<string, string>;
text: string;
children: WorkbookTableXmlElement[];
differentialStyle?: CellStyle;
} interface WorkbookTableXmlElement { name : string ; attributes : Record < string , string >; text : string ; children : WorkbookTableXmlElement []; differentialStyle ?: CellStyle ; } interface WorkbookTableXmlElement { name : string ; attributes : Record < string , string >; text : string ; children : WorkbookTableXmlElement []; differentialStyle ?: CellStyle ; } Bounded OOXML table-rule metadata. Names are unprefixed SpreadsheetML element names, not markup; the XLSX writer escapes text and attribute values. Keeping the rule tree avoids flattening date groups, custom filters or sort options into Sheetwrite's independently evaluated worksheet filters. API reference → interface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
fontFamily?: string;
color?: string;
backgroundColor?: string;
align?: CellAlign;
verticalAlign?: CellVerticalAlign;
numberFormat?: string;
wrap?: boolean;
border?: CellBorders;
} interface CellStyle { bold ?: boolean ; italic ?: boolean ; underline ?: boolean ; strikethrough ?: boolean ; fontSize ?: number ; fontFamily ?: string ; color ?: string ; backgroundColor ?: string ; align ?: CellAlign ; verticalAlign ?: CellVerticalAlign ; numberFormat ?: string ; wrap ?: boolean ; border ?: CellBorders ; } interface CellStyle { bold ?: boolean ; italic ?: boolean ; underline ?: boolean ; strikethrough ?: boolean ; fontSize ?: number ; fontFamily ?: string ; color ?: string ; backgroundColor ?: string ; align ?: CellAlign ; verticalAlign ?: CellVerticalAlign ; numberFormat ?: string ; wrap ?: boolean ; border ?: CellBorders ; } Serializable formatting applied to a cell or used as a column default. API reference →