Column.Visible Property

Gets or sets whether the column is visible or hidden.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool Visible { get; set; }

VB.NET

Property Visible As Boolean

Property Value

Type	Description
Boolean	true if the column is visible; otherwise false

Example

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).

View Example

RowAndColumnActions.cs

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;

RowAndColumnActions.vb

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

Related GitHub Examples

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.

C#

wpf-spreadsheetcontrol-api-part-1/CS/SpreadsheetControl_WPF_API/SpreadsheetActions/RowAndColumnActions.cs#L140

// Hide the 4th column of the worksheet.
worksheet.Columns[3].Visible = false;
#endregion #ShowHideRowsColumns

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.cs#L122

// Hide the fourth column.
worksheet.Columns[3].Visible = false;

winforms-spreadsheetcontrol-api-part1/CS/SpreadsheetControl/SpreadsheetActions/RowAndColumnActions.cs#L140

// Hide the 4th column of the worksheet.
worksheet.Columns[3].Visible = false;
#endregion #ShowHideRowsColumns

VB.NET

wpf-spreadsheetcontrol-api-part-1/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/RowAndColumnActions.vb#L140

            ' Hide the 4th column of the worksheet.
            worksheet.Columns(3).Visible = False
'            #End Region ' #ShowHideRowsColumns

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.vb#L107

' Hide the fourth column.
worksheet.Columns(3).Visible = False
' Hide columns from 5 to 7.

winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/RowAndColumnActions.vb#L141

            ' Hide the 4th column of the worksheet.
            worksheet.Columns(3).Visible = False
'            #End Region ' #ShowHideRowsColumns