wb.sheets

add(name?: string, index?: number): Promise<Worksheet>;

Add a new sheet to the workbook. @param name - Optional sheet name. Defaults to "SheetN". @param index - Optional 0-based position to insert the sheet. @returns The created Worksheet.

remove(target: number | string): Promise<SheetRemoveReceipt>;

Remove a sheet by index or name. Throws if attempting to remove the last sheet. @param target - 0-based index or sheet name.

move(name: string, toIndex: number): Promise<SheetMoveReceipt>;

Move a sheet to a new position. @param name - Sheet name (or identifier) to move. @param toIndex - Target 0-based index.

rename(target: number | string, newName: string): Promise<SheetRenameReceipt>;

Rename a sheet. @param target - 0-based index or current sheet name. @param newName - The new name for the sheet.

setActive(target: number | string): void | Promise<void>;

Set the active sheet. @param target - 0-based index or sheet name.

copy(source: number | string, newName?: string): Promise<Worksheet>;

Copy a sheet within the workbook. @param source - 0-based index or name of the sheet to copy. @param newName - Optional name for the copy. Defaults to "SheetName (Copy)". @returns The newly created Worksheet.

hide(target: number | string): Promise<SheetHideReceipt>;

Hide a sheet. Throws if attempting to hide the last visible sheet. @param target - 0-based index or sheet name.

show(target: number | string): Promise<SheetShowReceipt>;

Show (unhide) a sheet. @param target - 0-based index or sheet name.

setSelectedIds(sheetIds: string[]): Promise<void>;

Set which sheets are selected (multi-sheet selection for collaboration). @param sheetIds - Array of sheet IDs to mark as selected.

on(
    event: 'sheetAdded' | 'sheetRemoved' | 'sheetRenamed' | 'activeSheetChanged',
    handler: (event: any) => void,
  ): () => void;

Subscribe to sheet collection events. Fires for: sheetAdded, sheetRemoved, sheetRenamed, activeSheetChanged. @param event - Event type @param handler - Event handler @returns Unsubscribe function