Skip to content
Mondrian

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[];
};
PropertyTypeDescription
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 | 2Sheet 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_cellsstring[]-
namestring-
nextValueCellByCoords(row: number, col: number, dir: "left" | "right" | "up" | "down") => Cell | null-
rows?GridSize[]-
views?WorksheetView[]-