Skip to content

WorksheetView

type WorksheetView = {
activeCell?: CellId;
activeLayout?: "normal" | "pageLayout" | "pageBreakPreview";
activeRanges?: CellRange[];
layoutScales?: WorksheetLayoutScales;
showGridLines?: boolean;
workbookView: integer;
};
PropertyTypeDefault valueDescription
activeCell?CellIdundefined-
activeLayout?"normal" | "pageLayout" | "pageBreakPreview""normal"The layout used to display the worksheet.
activeRanges?CellRange[]undefined-
layoutScales?WorksheetLayoutScalesundefinedScale (aka zoom level, aka magnification) applied when displaying a worksheet. Each different layout has its own scale.
showGridLines?booleanundefined-
workbookViewintegerundefinedThe id of the workbook view this worksheet view belongs to. This is a zero-based index of the workbook view, as stored in the Workbook.views array. Within a single worksheet, each view must reference a distinct workbook view (i.e. no two views in the same worksheet can share the same workbookView id). However, views from different worksheets may reference the same workbook view.