Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
Wed Dec 13, 2017 2:14 pm
Hello
How can I find out if a special row or column is hidden? I couldn't find any related property.
Thanks
-
ahmadi_rad@yahoo.com
-
- Posts: 43
- Joined: Thu Apr 13, 2017 3:53 pm
Thu Dec 14, 2017 2:20 am
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
-
- Posts: 1156
- Joined: Tue Nov 29, 2016 1:47 am
Tue Dec 19, 2017 8:15 am
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
-
Jane.Bai
-
- Posts: 1156
- Joined: Tue Nov 29, 2016 1:47 am
Fri Dec 22, 2017 2:52 pm
Hello
Thanks for the reply. Problem is solved successfully.
Regards
-
ahmadi_rad@yahoo.com
-
- Posts: 43
- Joined: Thu Apr 13, 2017 3:53 pm
Mon Dec 25, 2017 7:15 am
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
-
Jane.Bai
-
- Posts: 1156
- Joined: Tue Nov 29, 2016 1:47 am