Working with the Window Object

The Window object represents an Excel window. You can use the Window object to position a window associated with a workbook. You can also use the Window object to set display settings for a workbook such as whether to display gridlines and headings.

Positioning a Window

The Window object lets you position and change the way Excel displays a workbook within a window. Window has a WindowState property of type XlWindowState that can be used to set the window to xlMaximized, xlMinimized, or xlNormal.

When the WindowState is set to xlNormal, you can position the window using the Left, Top, Width, and Height properties. These properties are double values that represent points, not screen pixels. You can use the Window's PointsToScreenPixelsX and PointsToScreenPixelsY methods to convert points to pixels.

Display Settings Associated with a Window

A number of additional properties allow you to control the display of a window. Table 5-12 lists some of the most commonly used ones.

Table 5-12. Window Properties That Control the Display of a Window

Property Name


What It Does



If set to false, Excel won't display gridlines around cells.



If set to false, Excel won't display the row and column headers.

Display HorizontalScrollBar


If set to false, Excel won't display the horizontal scroll bar.

Display VerticalScrollBar


If set to false, Excel won't display the vertical scroll bar.

Display WorkbookTabs


If set to false, Excel won't display the tabs to allow the user to switch to another worksheet.



If set to false, Excel won't let the user resize the window when WindowState is set to xlNormal.



Set to the color of the gridlines. Add a reference to your project to System.Drawing.dll and use the System.Drawing.ColorTranslator.ToOle method to generate a color Excel understands from a .NET color.



Sets the left column that the window should scroll to.



Sets the top row that the window should scroll to.



Sets the column number where the window will be split into vertical panes.



Sets the row number where the window will be split into horizontal panes.



Sets whether the window is visible.



Zooms the window; set to 100 to zoom to 100%, 200 to zoom to 200%, and so on.

Listing 5-21 shows an example of using many of these properties. Note that we add a reference to System.Drawing.dll so that we can use the ColorTranslator object to set the GridlineColor property. The ColorTranslator object provides a method called ToOle, which takes a System.Drawing color and converts it to an Ole color formatthe kind of color format that Office methods and properties that take colors expect.

Listing 5-21. A VSTO Customization That Controls the Display Options for a Window

private void ThisWorkbook_Startup(object sender, EventArgs e)
 Excel.Window win = this.NewWindow();

 win.WindowState = Excel.XlWindowState.xlNormal;
 win.Width = 200;
 win.Height = 200;
 win.Top = 8;
 win.Left = 8;
 win.DisplayGridlines = true;
 win.DisplayHeadings = false;
 win.DisplayHorizontalScrollBar = false;
 win.DisplayVerticalScrollBar = false;
 win.DisplayWorkbookTabs = false;
 win.EnableResize = false;

 win.GridlineColor = System.Drawing.ColorTranslator.

 win.ScrollColumn = 10;
 win.ScrollRow = 20;
 win.Visible = true;
 win.Zoom = 150;

Part One. An Introduction to VSTO

An Introduction to Office Programming

Introduction to Office Solutions

Part Two. Office Programming in .NET

Programming Excel

Working with Excel Events

Working with Excel Objects

Programming Word

Working with Word Events

Working with Word Objects

Programming Outlook

Working with Outlook Events

Working with Outlook Objects

Introduction to InfoPath

Part Three. Office Programming in VSTO

The VSTO Programming Model

Using Windows Forms in VSTO

Working with Actions Pane

Working with Smart Tags in VSTO

VSTO Data Programming

Server Data Scenarios

.NET Code Security


Part Four. Advanced Office Programming

Working with XML in Excel

Working with XML in Word

Developing COM Add-Ins for Word and Excel

Creating Outlook Add-Ins with VSTO

Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
ISBN: 321334884
Year: N/A
Pages: 214 © 2008-2020.
If you may any questions please contact us: