Sheet

Keikai provides Range methods to create, delete, and clone a sheet.

Create

createSheet(String name)

Delete

delete()

Clone

Clone the current sheet by cloneSheet(String name)

Clone a sheet from another Book e.g. a Book as a template by cloneSheetFrom(String name, Sheet sheet)

Hide/Unhide

Ranges.range(srcSpreadsheet.getSelectedSheet()).setSheetVisible(Range.SheetVisible.HIDDEN);
Ranges.range(srcSpreadsheet.getSelectedSheet()).setSheetVisible(Range.SheetVisible.VISIBLE);

Comments