Skip to content
Mondrian

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[];
};
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[] -