Excel Apps - Ability to programatically hide/unhide columns and rows
Hiding/Un-hiding rows and columns is a key feature requirement for using Office Apps for OLTP systems.
The main idea is to fill the gap between VSTO features and Office Apps. This will help in easy portability of VSTO based apps to Office apps.
Hari, thanks for the feedback! We’re happy to let you know that you can programmatically hide and unhide columns and rows by updating rowHidden and columnHidden of the range object.
Please take a look at https://github.com/OfficeDev/office-js-docs/blob/master/reference/excel/range.md.
Office Extensibility Team
Smart Owl commented
One of our custom features is to hide content by setting row height to 0 and then show the content by setting to row height back to some default value. Being able to do this on the desktop and the web version of Excel allows opening and using this feature on both environments.
Santosh Sutar commented
This feature will be great value to customers
Jim Bassett commented
Yes this would be great help allowing our customers to use the content in our custom Excel templates either on the Client or Web version of Excel.