WorkbookView
Overview
WorkbookView is a class in Aspose.Cells FOSS for Java.
Represents the view / window settings stored in <bookViews>.
This class provides 26 methods for working with WorkbookView objects in Java programs.
Available methods include: getActiveTab, getFirstSheet, getTabRatio, getVisibility, getWindowHeight, getWindowWidth, getXWindow, getYWindow, isAutoFilterDateGrouping, isMinimized, isShowHorizontalScroll, isShowSheetTabs, and 14 additional methods.
All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package.
Properties: activeTab, autoFilterDateGrouping, firstSheet, minimized, showHorizontalScroll, showSheetTabs, and 7 more.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
activeTab | int | Read | Zero-based index of the active worksheet (maps to bookView activeTab attribute). |
xWindow | Integer | Read | Gets the x window. |
yWindow | Integer | Read | Gets the y window. |
windowWidth | Integer | Read | Gets the window width. |
windowHeight | Integer | Read | Gets the window height. |
firstSheet | Integer | Read | Gets the first sheet. |
showHorizontalScroll | Boolean | Read | Gets the show horizontal scroll. |
showVerticalScroll | Boolean | Read | Gets the show vertical scroll. |
showSheetTabs | Boolean | Read | Gets the show sheet tabs. |
tabRatio | Integer | Read | Gets the tab ratio. |
visibility | String | Read | Gets the visibility. |
minimized | boolean | Read | Gets the minimized. |
autoFilterDateGrouping | boolean | Read | Gets the auto filter date grouping. |
Methods
| Signature | Description |
|---|---|
getActiveTab() → int | Zero-based index of the active worksheet (maps to bookView activeTab attribute). |
setActiveTab(v: int) | Sets the active tab value. |
getXWindow() → Integer | Returns the x window. |
setXWindow(v: Integer) | Sets the x window value. |
getYWindow() → Integer | Returns the y window. |
setYWindow(v: Integer) | Sets the y window value. |
getWindowWidth() → Integer | Returns the window width. |
setWindowWidth(v: Integer) | Sets the window width value. |
getWindowHeight() → Integer | Returns the window height. |
setWindowHeight(v: Integer) | Sets the window height value. |
getFirstSheet() → Integer | Returns the first sheet. |
setFirstSheet(v: Integer) | Sets the first sheet value. |
isShowHorizontalScroll() → Boolean | Returns true if show horizontal scroll is set. |
setShowHorizontalScroll(v: Boolean) | Sets the show horizontal scroll value. |
isShowVerticalScroll() → Boolean | Returns true if show vertical scroll is set. |
setShowVerticalScroll(v: Boolean) | Sets the show vertical scroll value. |
isShowSheetTabs() → Boolean | Returns true if show sheet tabs is set. |
setShowSheetTabs(v: Boolean) | Sets the show sheet tabs value. |
getTabRatio() → Integer | Returns the tab ratio. |
setTabRatio(v: Integer) | Sets the tab ratio value. |
getVisibility() → String | Returns the visibility. |
setVisibility(v: String) | Sets the visibility value. |
isMinimized() → boolean | Returns true if minimized is set. |
setMinimized(v: boolean) | Sets the minimized value. |
isAutoFilterDateGrouping() → boolean | Returns true if auto filter date grouping is set. |
setAutoFilterDateGrouping(v: boolean) | Sets the auto filter date grouping value. |