SpreadsheetGear 2010
Hidden Property
See Also  Example Send Feedback
SpreadsheetGear Namespace > IRange Interface : Hidden Property

Gets or sets the property which specifies whether rows or columns should be hidden.

Syntax

Visual Basic (Declaration) 
Property Hidden As Boolean
C# 
bool Hidden {get; set;}

Example

Hide column B of a worksheet.
C#Copy Code
// Create a worksheet.
IWorksheet worksheet = Factory.GetWorkbook().Worksheets[0];
 
// Hide column B of the worksheet.
worksheet.Cells["B:B"].Columns.Hidden = true;
Visual BasicCopy Code
' Create a worksheet.
Dim worksheet As IWorksheet = Factory.GetWorkbook().Worksheets(0)
  
' Hide column B of the worksheet.
worksheet.Cells("B:B").Columns.Hidden = True

Remarks

This property only works on ranges returned by IRange.Rows, IRange.EntireRows, IRange.Columns and IRange.EntireColumns.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 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.