SheetXL - v1.0.2
    Preparing search index...

    Interface Properties

    interface Properties {
        activeSheetId?: number | null;
        autoFilterDateGrouping?: boolean;
        firstTab?: number;
        minimized?: boolean;
        showFormulaBar?: boolean;
        showHorizontalScrollbar?: boolean;
        showStatusBar?: boolean;
        showTabs?: boolean;
        showVerticalScrollbar?: boolean;
        tabRatio?: number;
        visibility?: IWorkbookView.Visibility;
        windowBounds?: WindowBounds | null;
    }

    Hierarchy (View Summary)

    Index
    activeSheetId? autoFilterDateGrouping? firstTab? minimized? showFormulaBar? showHorizontalScrollbar? showStatusBar? showTabs? showVerticalScrollbar? tabRatio? visibility? windowBounds?
    activeSheetId?: number | null

    The id of of the activeSheet.

    This is NOT the index of the sheet but instead the id (1 based) If the sheets have been reordered then these won't match.

    autoFilterDateGrouping?: boolean

    Whether a filter's list groups dates by year, month and day.

    firstTab?: number

    The first sheet tab shown in the tab strip, by sheet index: how far the tabs are scrolled.

    minimized?: boolean

    Whether the workbook's window is minimized.

    showFormulaBar?: boolean

    Shows the visibility of the formula bar.

    showHorizontalScrollbar?: boolean

    show the horizontal scrollbar.

    showStatusBar?: boolean

    Show the status bar.

    showTabs?: boolean

    Shows the workbook tabs.

    showVerticalScrollbar?: boolean

    Show the vertical scrollbar.

    tabRatio?: number

    Specifies ratio between the workbook tabs and the horizontal scroll bar.

    This is expressed as a percent * 1000.

    visibility?: IWorkbookView.Visibility

    Whether the workbook's window is shown. A hidden window is how Excel keeps a workbook open out of sight, as its personal macro workbook does.

    windowBounds?: WindowBounds | null

    Where the workbook's window sits on the screen, in twips (a twentieth of a point).

    Settings
    Member Visibility

    On This Page
    Properties