WorkSheet
type WorkSheet = { columns?: GridSize[]; defaults?: { colWidth?: number; rowHeight?: number; }; getCellByCoords: (row: number, col: number) => Cell | null; getSize: () => [number, number]; hidden?: 0 | 1 | 2; merged_cells: string[]; name: string; nextValueCellByCoords: (row: number, col: number, dir: "left" | "right" | "up" | "down") => Cell | null; rows?: GridSize[]; views?: WorksheetView[];};Properties
Section titled “Properties”| Property | Type | Description |
|---|---|---|
columns? | GridSize[] | - |
defaults? | { colWidth?: number; rowHeight?: number; } | - |
defaults.colWidth? | number | - |
defaults.rowHeight? | number | - |
getCellByCoords | (row: number, col: number) => Cell | null | - |
getSize | () => [number, number] | - |
hidden? | 0 | 1 | 2 | Sheet visibility. - 0 = sheet is visible in the UI - 1 = sheet is hidden in the UI - 2 = sheet is [hidden”](https://exceloffthegrid.com/make-excel-sheets-very-hidden/ |
merged_cells | string[] | - |
name | string | - |
nextValueCellByCoords | (row: number, col: number, dir: "left" | "right" | "up" | "down") => Cell | null | - |
rows? | GridSize[] | - |
views? | WorksheetView[] | - |