WorkSheet
type WorkSheet = { columns?: GridSize[]; defaults?: { colWidth?: number; rowHeight?: number; }; drawings?: Drawing[]; getCellByRange: (range: { left: number; top: 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 |
- |
drawings? |
Drawing[] |
- |
getCellByRange |
(range: { left: number; top: 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/|"very |
merged_cells |
string[] |
- |
name |
string |
- |
nextValueCellByCoords |
(row: number, col: number, dir: "left" | "right" | "up" | "down") => Cell | null |
- |
rows? |
GridSize[] |
- |
views? |
WorksheetView[] |
- |