Set show/hide rows/columns.(Microsoft Excel Office Scripts)
Introduction to showing and hiding rows and columns using Office scripts.
Contents
Operations
The following syntax is used (Red text indicates variable parts)
// Set show/hide columns
workbook.getWorksheet("Sheet name").getRange("Columns").setColumnHidden(true/false);
// Set show/hide row
workbook.getWorksheet("Sheet name").getRange("Rows").setRowHidden(true/false);
Specify true to hide or false to reshow.

For those who want to learn Office script effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.
Discussion
New Comments
No comments yet. Be the first one!