Determine if a row or column is hidden

[Matthew]

Using XLSIO 4.4.x, I can't seem to find a way to determine if a row or column is already hidden. How would I accomplish that?

[Melba Winshia]

Hi Matthew,

You can use IsColumnVisible and IsRowVisible property to detect if a row/column was hidden. Please refer the following code snippet which illustrates the above:

[C#]

bool column = sheet.IsColumnVisible(1);
bool row = sheet.IsRowVisible(1);
MessageBox.Show(column.ToString(),"Hidden or not");

Please refer the following sample which implements the above said feature:

Hide.zip

Kindly take a look at the sample above and let me know if you have any other questions.

Thanks,
Melba

[Administrator]

Thanks, I'm not sure how I missed that before.

You might consider adding a seealso to the help documentation between these entries and the ShowRow, ShowColumn entries. Also, a note in the FAQ on how to hide rows/columns might mention this as well.

[Melba Winshia]

Hi Matthew,

Thanks for the update!

Sure we will include this in our documentation and FAQ.

Kindly let me know if you have any other questions.

Regards,
Melba