Excel Apps - Ability to enable/disable rows and columns programatically
Enabling/Disabling 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 your suggestion! We’re happy to report that OfficeJs supports this feature. You can use range.rowHidden and range.columnHidden to hide and unhide the columns.
Please feel free to contact us if you’ve any more feedback.
Office Extensibility Team
Smart Owl commented
I agree with Hari's need
I have a data entry application on a excel form using VSTO. I am enabling the excel columns based some conditions. I am able to do that in VSTO, but not in Excel web apps