Hide Rows and Columns"
From Documentation
| Line 6: | Line 6: | ||
'''Hide and unhide selected row''' | '''Hide and unhide selected row''' | ||
| − | <source lang='java'> | + | <source lang='java' high="3"> |
//convert to column range or row range before hiding or unhiding. | //convert to column range or row range before hiding or unhiding. | ||
Range rowRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | Range rowRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | ||
| Line 19: | Line 19: | ||
'''Hide a column''' | '''Hide a column''' | ||
| − | <source lang='java'> | + | <source lang='java' high="2"> |
Range columnRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | Range columnRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | ||
columnRange = columnRange.toColumnRange(); | columnRange = columnRange.toColumnRange(); | ||
Revision as of 07:13, 13 August 2013
Hiding rows or columns may come in handy when we don't need some cells temporarily. Before hiding (or unhiding) rows or columns by API, you should make your selection become row selection or column selections by Range.toRowRange() or Range.toColumnRange(). Here are examples:
Hide and unhide selected row
//convert to column range or row range before hiding or unhiding.
Range rowRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
rowRange = rowRange.toRowRange();
rowRange.setHidden(true);
//CellOperationUtil checks sheet protection before hiding a range
CellOperationUtil.hide(rowRange);
CellOperationUtil.unhide(rowRange);
Hide a column
Range columnRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
columnRange = columnRange.toColumnRange();
columnRange.setHidden(true);
If you don't convert it before calling API, it won't take effect.
All source code listed in this book is at Github.