3.7.5.98 Wbk


The WBK object has properties and methods related to the active Origin Workbook or Matrixbook. The object properties and methods can be accessed using the following syntax:

wbkObject.property
wbkObject.method (argument)

Note:

In addition to the WBK object, most attributes can be accessed and changed using the Page object. Also, many operations on child windows can be done by Window command. For more operations and examples, please refer to Basic Workbook Operation and Basic Matrix Operation.


Properties

Property Access Description
wbk.canAddDC Read
bool
Return whether the workbook can be used to add Data Connector, 1 = ture, 0 = false.
wbk.DC Read/write Data Connector settings. See also: The Wbk.DC object properties.
wbk.image Read
bool
Toggle Data Mode (=0) or Image Mode (=1).
wbk.organizer Read/write
bool
Show or hide the workbook or matrixbook Organizer. 0 = hide, 1 = show.
wbk.saveData Read/write
bool
Whether to save the imported data in the workbook when saving a project (as .opju) or workbook window (as .ogwu): 0 = exclude the imported data while other data (from typing, calculation or other performances) will remain, 1 = save the imported data
wbk.selector Read/write
bool
Displays the thumbnail/selector region between the matrixbook grid and the window title bar. 0 = hide, 1 = show.
wbk.showXY Read/write
bool
Toggle display of Column/Row (=0) or X/Y (=1).
wbk.slider Read/write
bool
Toggles between display of slider or image thumbnails in the region between the matrixbook grid and the window title bar. 0 = show thumbnails, 1 = show slider.

Methods

Method Description
wbk.open(sheetName) Open the embedded sheetName in a window. sheetName can be Notes, Graph or Matrix. For example, if you add a graph window as a worksheet to the current workbook by right clicking on a current worksheet tab and select menu item Add Graph as Sheet, and rename the worksheet as MyGraph, you can run
wbk.OPEN(MyGraph);

to open the graph in a separated window.

Examples

See Also

Wks Wbk.DC Wks.DC