SpreadsheetGear
IWorksheetWindowInfo Interface
Members  Example  See Also  Send Feedback
SpreadsheetGear Namespace : IWorksheetWindowInfo Interface

Represents worksheet specific window information.

Syntax

Visual Basic (Declaration) 
Public Interface IWorksheetWindowInfo
C# 
public interface IWorksheetWindowInfo

Example

C#Copy Code
// Demonstrates creating a workbook with frozen panes
// using IWindowInfo.FreezePanes.
internal static void FreezePanes()
{
   // Create a workbook.
   SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
   SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets[0];
   worksheet.Name = "Freeze Panes";

   // Split after column "C" (ScrollColumn is zero based).
   worksheet.WindowInfo.ScrollColumn = 2;
   worksheet.WindowInfo.SplitColumns = 1;

   // Split after row 2 (ScrollRow is zero based).
   worksheet.WindowInfo.ScrollRow = 1;
   worksheet.WindowInfo.SplitRows = 1;

   // Freeze the panes.
   worksheet.WindowInfo.FreezePanes = true;

   // Select the first non-frozen cell.
   SpreadsheetGear.IRange d3 = worksheet.Cells["D3"];
   d3.Select();

   // Enter some data in the frozen rows/cols.
   worksheet.Cells["C2"].Value = "Worksheet Title";
   worksheet.Cells["D2"].Value = "Column Title";
   worksheet.Cells["C3"].Value = "Row Title";

   // Enter some data in D3, format the cell, and unlock the cell
   // so it can bew edited after setting worksheet.ProtectContents to true.
   d3.Value = "Edit Me";
   SpreadsheetGear.IFont font = d3.Font;
   font.Name = "Tahoma";
   font.Size = 16.0;
   font.Color = System.Drawing.Color.Blue;
   d3.Locked = false;

   // Autofit the columns.
   worksheet.UsedRange.Columns.AutoFit();

   // Auto size the columns.
   // Protect locked ce4lls.
   worksheet.ProtectContents = true;

   // Save the workbook.
   workbook.SaveAs(@"c:\FreezePanes.xls", SpreadsheetGear.FileFormat.XLS97);
}
Visual BasicCopy Code
' Demonstrates creating a workbook with frozen panes
' using IWindowInfo.FreezePanes.
Friend Shared Sub FreezePanes()
    ' Create a workbook.
    Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
    Dim worksheet As SpreadsheetGear.IWorksheet = workbook.Worksheets(0)
    worksheet.Name = "Freeze Panes"

    ' Split after column "C" (ScrollColumn is zero based).
    worksheet.WindowInfo.ScrollColumn = 2
    worksheet.WindowInfo.SplitColumns = 1

    ' Split after row 2 (ScrollRow is zero based).
    worksheet.WindowInfo.ScrollRow = 1
    worksheet.WindowInfo.SplitRows = 1

    ' Freeze the panes.
    worksheet.WindowInfo.FreezePanes = True

    ' Select the first non-frozen cell.
    Dim d3 As SpreadsheetGear.IRange = worksheet.Cells("D3")
    d3.Select()

    ' Enter some data in the frozen rows/cols.
    worksheet.Cells("C2").Value = "Worksheet Title"
    worksheet.Cells("D2").Value = "Column Title"
    worksheet.Cells("C3").Value = "Row Title"

    ' Enter some data in D3, format the cell, and unlock the cell
    ' so it can bew edited after setting worksheet.ProtectContents to true.
    d3.Value = "Edit Me"
    Dim font As SpreadsheetGear.IFont = d3.Font
    font.Name = "Tahoma"
    font.Size = 16.0
    font.Color = System.Drawing.Color.Blue
    d3.Locked = False

    ' Autofit the columns.
    worksheet.UsedRange.Columns.AutoFit()

    ' Auto size the columns.
    ' Protect locked ce4lls.
    worksheet.ProtectContents = True

    ' Save the workbook.
    workbook.SaveAs("c:\freezepanevb.xls", SpreadsheetGear.FileFormat.XLS97)
End Sub 'FreezePanes '

Requirements

Namespace: SpreadsheetGear

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.