Edit

Share via

Excel.Interfaces.WindowUpdateData interface

Package:
excel

An interface for updating data on the Window object, for use in window.set({ ... }).

Properties

activeCell

Specifies the active cell in the window.
activeWorksheet

Specifies the active sheet in the window.
autoFilterDateGroupingEnabled

Specifies whether AutoFilter date grouping is enabled in the window.
freezePanes

Specifies whether panes are frozen in the window.
height

Specifies the height of the window.
isVisible

Specifies whether the window is visible.
left

Specifies the distance, in points, from the left edge of the computer screen to the left edge of the window.
name

Specifies the name of the window.
rangeSelection

Gets the range selection in the window.
scrollColumn

Specifies the scroll column of the window.
scrollRow

Specifies the scroll row of the window.
showFormulas

Specifies whether formulas are shown in the window.
showGridlines

Specifies whether gridlines are shown in the window.
showHeadings

Specifies whether headings are shown in the window.
showHorizontalScrollBar

Specifies whether the horizontal scroll bar is shown in the window.
showOutline

Specifies whether outline is shown in the window.
showRuler

Specifies whether the ruler is shown in the window.
showVerticalScrollBar

Specifies whether the vertical scroll bar is shown in the window.
showWhitespace

Specifies whether whitespace is shown in the window.
showWorkbookTabs

Specifies whether workbook tabs are shown in the window.
showZeros

Specifies whether zeroes are shown in the window.
split

Specifies the split state of the window.
splitColumn

Specifies the split column of the window.
splitHorizontal

Specifies the horizontal split of the window.
splitRow

Specifies the split row of the window.
splitVertical

Specifies the vertical split of the window.
tabRatio

Specifies the tab ratio of the window.
top

Specifies the distance, in points, from the top edge of the window to the top edge of the usable area (below the menus, any toolbars docked at the top, and the formula bar).
view

Specifies the view of the window.
visibleRange

Gets the visible range of the window.
width

Specifies the display width of the window.
windowState

Specifies the window state.
zoom

Specifies an integer value that represents the display size of the window. It can be set to a percentage between 10 and 400.

Property Details

activeCell

Specifies the active cell in the window.

activeCell?: Excel.Interfaces.RangeUpdateData;

Property Value

Excel.Interfaces.RangeUpdateData

Remarks

[ API set: ExcelApiDesktop 1.1 ]

activeWorksheet

Specifies the active sheet in the window.

activeWorksheet?: Excel.Interfaces.WorksheetUpdateData;

Property Value

Excel.Interfaces.WorksheetUpdateData

Remarks

[ API set: ExcelApiDesktop 1.1 ]

autoFilterDateGroupingEnabled

Specifies whether AutoFilter date grouping is enabled in the window.

autoFilterDateGroupingEnabled?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

freezePanes

Specifies whether panes are frozen in the window.

freezePanes?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

height

Specifies the height of the window.

height?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

isVisible

Specifies whether the window is visible.

isVisible?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

left

Specifies the distance, in points, from the left edge of the computer screen to the left edge of the window.

left?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

name

Specifies the name of the window.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApiDesktop 1.1 ]

rangeSelection

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Gets the range selection in the window.

rangeSelection?: Excel.Interfaces.RangeAreasUpdateData;

Property Value

Excel.Interfaces.RangeAreasUpdateData

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

scrollColumn

Specifies the scroll column of the window.

scrollColumn?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

scrollRow

Specifies the scroll row of the window.

scrollRow?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showFormulas

Specifies whether formulas are shown in the window.

showFormulas?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showGridlines

Specifies whether gridlines are shown in the window.

showGridlines?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showHeadings

Specifies whether headings are shown in the window.

showHeadings?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showHorizontalScrollBar

Specifies whether the horizontal scroll bar is shown in the window.

showHorizontalScrollBar?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showOutline

Specifies whether outline is shown in the window.

showOutline?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showRuler

Specifies whether the ruler is shown in the window.

showRuler?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showVerticalScrollBar

Specifies whether the vertical scroll bar is shown in the window.

showVerticalScrollBar?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showWhitespace

Specifies whether whitespace is shown in the window.

showWhitespace?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showWorkbookTabs

Specifies whether workbook tabs are shown in the window.

showWorkbookTabs?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

showZeros

Specifies whether zeroes are shown in the window.

showZeros?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

split

Specifies the split state of the window.

split?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApiDesktop 1.1 ]

splitColumn

Specifies the split column of the window.

splitColumn?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

splitHorizontal

Specifies the horizontal split of the window.

splitHorizontal?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

splitRow

Specifies the split row of the window.

splitRow?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

splitVertical

Specifies the vertical split of the window.

splitVertical?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

tabRatio

Specifies the tab ratio of the window.

tabRatio?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

top

Specifies the distance, in points, from the top edge of the window to the top edge of the usable area (below the menus, any toolbars docked at the top, and the formula bar).

top?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

view

Specifies the view of the window.

view?: Excel.WindowView | "normalView" | "pageBreakPreview" | "pageLayoutView";

Property Value

Excel.WindowView | "normalView" | "pageBreakPreview" | "pageLayoutView"

Remarks

[ API set: ExcelApiDesktop 1.1 ]

visibleRange

Gets the visible range of the window.

visibleRange?: Excel.Interfaces.RangeUpdateData;

Property Value

Excel.Interfaces.RangeUpdateData

Remarks

[ API set: ExcelApiDesktop 1.1 ]

width

Specifies the display width of the window.

width?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]

windowState

Specifies the window state.

windowState?: Excel.WindowState | "maximized" | "minimized" | "normal";

Property Value

Excel.WindowState | "maximized" | "minimized" | "normal"

Remarks

[ API set: ExcelApiDesktop 1.1 ]

zoom

Specifies an integer value that represents the display size of the window. It can be set to a percentage between 10 and 400.

zoom?: number;

Property Value

number

Remarks

[ API set: ExcelApiDesktop 1.1 ]