officefileapi-devexpress-dot-spreadsheet-dot-column-14c2ec61.md
Gets or sets whether the column is visible or hidden.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool Visible { get; set; }
Property Visible As Boolean
| Type | Description |
|---|---|
| Boolean |
true if the column is visible; otherwise false
|
This example demonstrates how to control the visibility of rows and columns in a worksheet using the Row.Visible and Column.Visible properties.
Note
You can also hide a row or column in a worksheet by setting the row height (Row.Height) or column width (Column.Width, Column.WidthInCharacters or Column.WidthInPixels) to 0, respectively (see the How to: Specify Row Height or Column Width document).
Worksheet worksheet = workbook.Worksheets[0];
// Hide the 8th row of the worksheet.
worksheet.Rows[7].Visible = false;
// Hide the 4th column of the worksheet.
worksheet.Columns[3].Visible = false;
Dim worksheet As Worksheet = workbook.Worksheets(0)
' Hide the 8th row of the worksheet.
worksheet.Rows(7).Visible = False
' Hide the 4th column of the worksheet.
worksheet.Columns(3).Visible = False
The following code snippets (auto-collected from DevExpress Examples) contain references to the Visible property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
// Hide the 4th column of the worksheet.
worksheet.Columns[3].Visible = false;
#endregion #ShowHideRowsColumns
// Hide the 4th column of the worksheet.
worksheet.Columns[3].Visible = false;
#endregion #ShowHideRowsColumns
// Hide the fourth column.
worksheet.Columns[3].Visible = false;
' Hide the 4th column of the worksheet.
worksheet.Columns(3).Visible = False
' #End Region ' #ShowHideRowsColumns
' Hide the 4th column of the worksheet.
worksheet.Columns(3).Visible = False
' #End Region ' #ShowHideRowsColumns
' Hide the fourth column.
worksheet.Columns(3).Visible = False
' Hide columns from 5 to 7.
See Also