Hide or Show Rows and Columns in Excel using C#

HideUnhideRowsColumns_CSharp.md

Learn how to hide or show rows and columns of an Excel sheet using C#: https://blog.conholdate.com/2021/09/28/hide-and-show-rows-or-columns-in-excel-using-csharp/

The following topics are discussed/covered here:

1. Hide Rows and Columns using C#
2. Show Hidden Rows and Columns using C#
3. Hide Multiple Rows and Columns using C#
4. Show All Rows and Columns using C#

HideUnhideRowsColumns_CSharp_Hide.cs

// Instantiate a workbook
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Hiding the 3rd row of the worksheet
worksheet.Cells.HideRow(2);

// Hiding the 2nd column of the worksheet
worksheet.Cells.HideColumn(1);

// Saving the modified Excel file
workbook.Save(@"C:\Files\HideRowsColumns.xlsX");

HideUnhideRowsColumns_CSharp_HideMultiple.cs

// Instantiate a Workbook
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Hiding 3,4 and 5 rows in the worksheet
worksheet.Cells.HideRows(2, 3);

// Hiding 2 and 3 columns in the worksheet
worksheet.Cells.HideColumns(1, 2);

// Saving the modified Excel file
workbook.Save(@"C:\Files\HideMultiple.xlsx");

HideUnhideRowsColumns_CSharp_Show.cs

// Instantiate a workbook
Workbook workbook = new Workbook(@"C:\Files\HideRowsColumns.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Unhiding the 3rd row and setting its height to 13.5
worksheet.Cells.UnhideRow(2, 13.5);

// Unhiding the 2nd column and setting its width to 8.5
worksheet.Cells.UnhideColumn(1, 20.5);

// Saving the modified Excel file
workbook.Save(@"C:\Files\ShowRowsColumns.xlsx");

HideUnhideRowsColumns_CSharp_ShowAll.cs

// Instantiate a Workbook
Workbook workbook = new Workbook(@"C:\Files\HideMultiple.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Show all rows
var AllRows = worksheet.Cells.Rows;
foreach (Row row in AllRows)
{
    if (row.IsHidden)
    {
        worksheet.Cells.UnhideRow(row.Index, 20.5);
    }
}

// Show all columns
var AllColumns = worksheet.Cells.Columns;
foreach (var column in AllColumns)
{
    if (column.IsHidden)
    {
        worksheet.Cells.UnhideColumn(column.Index, 20.5);
    }
}

// Saving the modified Excel file
workbook.Save(@"C:\Files\ShowAllRowsColumns.xlsx");