 |
 |
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > IRange Interface : Hidden Property |
|
|
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > IRange Interface : Hidden Property |
Gets or sets the property which specifies whether rows or columns should be hidden.
[Visual Basic]
Overridable Property Hidden As Boolean [C#]
virtual bool Hidden {get; set;}[C++]
__property virtual bool get_Hidden();
__property virtual void set_Hidden(
bool value
);[C++/CLI]
virtual property bool Hidden {
bool get();
void set (bool value);
}This property only works on ranges returned by IRange.Rows, IRange.EntireRows, IRange.Columns and IRange.EntireColumns.
[C#] Hide column B of a worksheet.
// Create a worksheet.
IWorksheet worksheet = Factory.GetWorkbook().Worksheets[0];
// Hide column B of the worksheet.
worksheet.Cells["B:B"].Columns.Hidden = true;
[Visual Basic]
' Create a worksheet.
Dim worksheet As IWorksheet = Factory.GetWorkbook().Worksheets(0)
' Hide column B of the worksheet.
worksheet.Cells("B:B").Columns.Hidden = True
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
IRange Interface | IRange Members
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.