public void setSheetHidden(int sheetIx, int hidden) { validateSheetIndex(sheetIx); WorkbookUtil.validateSheetState(hidden); workbook.setSheetHidden(sheetIx, hidden); }
public void setSheetHidden(int sheetIx, int hidden) { validateSheetIndex(sheetIx); WorkbookUtil.validateSheetState(hidden); workbook.setSheetHidden(sheetIx, hidden); }
/** * Hide or unhide a sheet. * * <ul> * <li>0 - visible. </li> * <li>1 - hidden. </li> * <li>2 - very hidden.</li> * </ul> * @param sheetIx the sheet index (0-based) * @param state one of the following <code>Workbook</code> constants: * <code>Workbook.SHEET_STATE_VISIBLE</code>, * <code>Workbook.SHEET_STATE_HIDDEN</code>, or * <code>Workbook.SHEET_STATE_VERY_HIDDEN</code>. * @throws IllegalArgumentException if the supplied sheet index or state is invalid */ public void setSheetHidden(int sheetIx, int state) { validateSheetIndex(sheetIx); WorkbookUtil.validateSheetState(state); CTSheet ctSheet = sheets.get(sheetIx).sheet; ctSheet.setState(STSheetState.Enum.forInt(state + 1)); }