Hiding Rows and Columns in Worksheet

Aspose.Cells - Hiding Rows and Columns in Worksheet

C#

Workbook workbook = new Workbook();

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

worksheet.Cells["A1"].PutValue("1");
worksheet.Cells["A2"].PutValue("2");
worksheet.Cells["B1"].PutValue(11);

// Hiding the 1st row of the worksheet
worksheet.Cells.HideRow(0);

// Hiding the 1st column of the worksheet
worksheet.Cells.HideColumn(0);

// Saving the modified Excel file
workbook.Save("Output-HideRowsandColumns.xls");

NPOI - HSSF XSSF - Hiding Rows and Columns in Worksheet

C#

HSSFWorkbook hssfworkbook = new HSSFWorkbook();
ISheet s = hssfworkbook.CreateSheet("Sheet1");

IRow r1 = s.CreateRow(0);
IRow r2 = s.CreateRow(1);

// Hide Row 0
r1.ZeroHeight = true;

// Hide column A
s.SetColumnHidden(0, true);

FileStream file = new FileStream(@"HidingRowsandColumn(NPOI).xls", FileMode.Create);
hssfworkbook.Write(file);
file.Close();

Download Running Code

Download Hiding Rows and Columns in Worksheet from any of the below mentioned social coding sites:

• GitHub

For more details, visit Working with Worksheets.