Is there any way to find Cell is hidden or not in Worksheet

naresh.dongarigmail · July 2, 2017, 10:14pm

Hi,

Is there any way to find a particular Cell is hidden or not in Worksheet ,like to find a row is hidden or not with help of Aspose.Cells.Row IsHidden option.

Thanks,

Naresh.

Amjad_Sahi · July 2, 2017, 10:14pm

Hi,

Well, for your information, in MS Excel, when a cell is set as hidden or not visible anymore in Excel sheet, it means certain row / corresponding row or corresponding column is automatically set as hidden. So, you will always use cells’ Row.IsHidden or Column.IsHidden attribute to get to know if certain cells in the criteria are visible or not.

Thank you.