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 Basic | Copy Code |
---|
Friend Shared Sub FreezePanes()
Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
Dim worksheet As SpreadsheetGear.IWorksheet = workbook.Worksheets(0)
worksheet.Name = "Freeze Panes"
worksheet.WindowInfo.ScrollColumn = 2
worksheet.WindowInfo.SplitColumns = 1
worksheet.WindowInfo.ScrollRow = 1
worksheet.WindowInfo.SplitRows = 1
worksheet.WindowInfo.FreezePanes = True
Dim d3 As SpreadsheetGear.IRange = worksheet.Cells("D3")
d3.Select()
worksheet.Cells("C2").Value = "Worksheet Title"
worksheet.Cells("D2").Value = "Column Title"
worksheet.Cells("C3").Value = "Row Title"
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
worksheet.UsedRange.Columns.AutoFit()
worksheet.ProtectContents = True
workbook.SaveAs("c:\freezepanevb.xls", SpreadsheetGear.FileFormat.XLS97)
End Sub
|
Requirements
Namespace: SpreadsheetGear
Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. 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