Find if a row or column is hidden

[ahmadi_rad@yahoo.com]

Hello

How can I find out if a special row or column is hidden? I couldn't find any related property.

Thanks

[Jane.Bai]

Hello,

Thanks for your inquiry. You could use "IsRowVisible" and "IsColumnVisible" method to detect whether a row or a column is hidden.
Please refer to the below code.

Code: Select all

  Workbook book = new Workbook();
  book.LoadFromFile(path);
  Worksheet sheet = book.Worksheets[0];
  //eg. detect whether the fourth row or the second column is hidden.
  sheet.IsRowVisible(4);
  sheet.IsColumnVisible(2);


Sincerely,
Jane
E-iceblue support team

[Jane.Bai]

Hello,

Greetings from e-iceblue!
I wonder if your issue has been resolved? Could you please give us some feedback?

Sincerely,
Jane
E-iceblue support team

[ahmadi_rad@yahoo.com]

Hello

Thanks for the reply. Problem is solved successfully.

Regards

[Jane.Bai]

Hello,

Thanks for your valuable feedback and Merry Christmas!
Please feel free to contact us if you need any assistance.

Sincerely,
Jane
E-iceblue support team