Hide Columns & Rows in an Excel sheet

[Charith Jayasundara]

How can I hide columns and rows in a excel sheet? Please give me with code examples. Thanks!

[Sandeep Kumar]

Hi.... The code will look like Range usedRng1 = (Range)_ExcByAppWorkSheet.get_Range("A1", Type.Missing).Select(); usedRng1.EntireColumn.Hidden = true;

Regards, Sandeep Kumar.V

[pcthao]

thanks! it works :laugh:

Range range = (Range)WorkSheet.get_Range("A1", Missing.Value);
range.EntireColumn.Hidden = true;
....
range.EntireRow.Hidden = true;

modified on Friday, December 24, 2010 9:12 AM