WorkSheet
Constructors
Section titled “Constructors”Constructor
Section titled “Constructor”new WorkSheet(jsf: Worksheet, wb: Workbook): WorkSheet;Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
jsf | Worksheet |
wb | Workbook |
Returns
Section titled “Returns”WorkSheet
Properties
Section titled “Properties”| Property | Type |
|---|---|
_size | [number, number] |
cells | Map<number, Cell> |
columns | GridSize[] |
colWidths | Record<number, number> | null |
comments | ThreadedComment[] |
defaults | WorksheetDefaults |
drawings? | Drawing[] |
hidden | 0 | 1 | 2 |
merged_cells | string[] |
name | string |
notes | Note[] |
rows | GridSize[] |
views? | WorksheetView[] |
workbook | Workbook |
Methods
Section titled “Methods”getCellByCoords()
Section titled “getCellByCoords()”getCellByCoords(row: number, col: number): Cell | null;Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
row | number |
col | number |
Returns
Section titled “Returns”Cell | null
getSize()
Section titled “getSize()”getSize(): [number, number];Returns
Section titled “Returns”[number, number]
nextValueCellByCoords()
Section titled “nextValueCellByCoords()”nextValueCellByCoords( row: number, col: number, dir: "left" | "right" | "up" | "down"): Cell | null;Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
row | number |
col | number |
dir | "left" | "right" | "up" | "down" |
Returns
Section titled “Returns”Cell | null