api/book Functions

function addCellComment(cell: CellObject, text: string, author?: string): void

function appendSheet(wb: WorkBook, ws: WorkSheet, name?: string, roll?: boolean): string

function createSheet(opts?: { dense?: boolean }): WorkSheet

function createWorkbook(ws?: WorkSheet, wsname?: string): WorkBook

function freezePanes(ws: WorkSheet, pane: { xSplit?: number; ySplit?: number }): WorkSheet

function getSheetIndex(wb: WorkBook, sh: string | number): number

function mergeCells(ws: WorkSheet, range: string | Range): WorkSheet

function setArrayFormula(ws: WorkSheet, range: string | { s: { r: number; c: number }; e: { r: number; c: number } }, formula: string, dynamic?: boolean): WorkSheet

function setCellHyperlink(cell: CellObject, target?: string, tooltip?: string): CellObject

function setCellInternalLink(cell: CellObject, range: string, tooltip?: string): CellObject

function setCellNumberFormat(cell: CellObject, fmt: string | number): CellObject

function setCellStyle(cell: CellObject, style: CellStyle): CellObject

function setColumnWidth(ws: WorkSheet, col: number, width: number): WorkSheet

function setRowHeight(ws: WorkSheet, row: number, hpt: number): WorkSheet

function setSheetVisibility(wb: WorkBook, sh: string | number, vis: 0 | 1 | 2): void

function sheetToFormulae(ws: WorkSheet, opts?: WorksheetCellBudgetOptions): string[]

function styleRange(ws: WorkSheet, range: string | Range, style: CellStyle, opts?: { createCells?: boolean }): WorkSheet