Member Junction
    Preparing search index...

    Interface SheetDefinition

    Sheet definition for multi-sheet exports

    interface SheetDefinition {
        alternateRowStyle?: CellStyle;
        autoFilter?: string | boolean;
        cellStyles?: CellStyleOverride[];
        columns?: ExportColumn[];
        columnWidths?: number[];
        conditionalFormatting?: ConditionalFormatRule[];
        data: ExportData;
        dataStyle?: CellStyle;
        dataValidation?: DataValidationRule[];
        defaultColWidth?: number;
        defaultRowHeight?: number;
        formulas?: CellFormula[];
        freeze?: { column?: number; row?: number };
        headers?: string[];
        headerStyle?: CellStyle;
        images?: EmbeddedImage[];
        includeHeaders?: boolean;
        mergedCells?: MergedCellRange[];
        name: string;
        outlineProperties?: { summaryBelow?: boolean; summaryRight?: boolean };
        pageSetup?: PageSetup;
        protection?: SheetProtection;
        rightToLeft?: boolean;
        rowStyles?: RowStyle[];
        showGridLines?: boolean;
        tabColor?: string;
    }
    Index

    Properties

    alternateRowStyle? autoFilter? cellStyles? columns? columnWidths? conditionalFormatting? data dataStyle? dataValidation? defaultColWidth? defaultRowHeight? formulas? freeze? headers? headerStyle? images? includeHeaders? mergedCells? name outlineProperties? pageSetup? protection? rightToLeft? rowStyles? showGridLines? tabColor?

    Properties

    alternateRowStyle?: CellStyle

    Alternating row style

    autoFilter?: string | boolean

    Auto-filter range (e.g., 'A1:D100' or true for all data)

    cellStyles?: CellStyleOverride[]

    Specific cell style overrides

    columns?: ExportColumn[]

    Column definitions (optional, derived from data if not provided)

    columnWidths?: number[]

    Column widths in characters

    conditionalFormatting?: ConditionalFormatRule[]

    Conditional formatting rules

    data: ExportData

    Data rows for this sheet

    dataStyle?: CellStyle

    Default data row style

    dataValidation?: DataValidationRule[]

    Data validation rules

    defaultColWidth?: number

    Default column width

    defaultRowHeight?: number

    Default row height

    formulas?: CellFormula[]

    Formulas to add

    freeze?: { column?: number; row?: number }

    Freeze panes configuration

    Type Declaration

    • Optionalcolumn?: number

      Freeze at column (1-based, columns left of this are frozen)

    • Optionalrow?: number

      Freeze at row (1-based, rows above this are frozen)

    headers?: string[]

    Custom column headers (alternative to columns)

    headerStyle?: CellStyle

    Header row style

    images?: EmbeddedImage[]

    Embedded images

    includeHeaders?: boolean

    Include headers row

    mergedCells?: MergedCellRange[]

    Merged cell ranges

    name: string

    Sheet name (required)

    outlineProperties?: { summaryBelow?: boolean; summaryRight?: boolean }

    Outline/grouping settings

    Type Declaration

    • OptionalsummaryBelow?: boolean

      Summary rows below detail

    • OptionalsummaryRight?: boolean

      Summary columns to right of detail

    pageSetup?: PageSetup

    Page setup for printing

    protection?: SheetProtection

    Sheet protection options

    rightToLeft?: boolean

    Right-to-left reading order

    rowStyles?: RowStyle[]

    Specific row styles

    showGridLines?: boolean

    Show gridlines

    tabColor?: string

    Tab color (hex without #)

    Settings

    Member Visibility

    On This Page

    Properties