SheetXL - v0.3.20
    Preparing search index...

    Interface JSON

    A JSON representation useful for persistence.

    interface JSON {
        columnHeaderStyle?: HeaderTextStyle;
        gridLineColor?: string | IColor;
        rowHeaderStyle?: HeaderTextStyle;
        showColumnGridlines?: boolean;
        showColumnHeaders?: boolean;
        showFormulas?: boolean;
        showRowGridlines?: boolean;
        showRowHeaders?: boolean;
        showZeros?: boolean;
    }

    Hierarchy

    • Omit<
          ISheetView.Properties,
          "selection"
          | "topLeft"
          | "freezePanes"
          | "zoomScale",
      >
      • JSON
    Index

    Properties

    columnHeaderStyle? gridLineColor? rowHeaderStyle? showColumnGridlines? showColumnHeaders? showFormulas? showRowGridlines? showRowHeaders? showZeros?

    Properties

    columnHeaderStyle?: HeaderTextStyle

    Style of displaying default row header column Note - This does not affect how formulas are resolved

    gridLineColor?: string | IColor

    The color of the gridline on the sheet.

    GridLine color is a sheet view attribute but in Excel is a workbook attribute. If null then use the app theme.

    rowHeaderStyle?: HeaderTextStyle

    Style of displaying default row header text Note - This does not affect how formulas are resolved

    showColumnGridlines?: boolean

    Show/Hide column gridlines.

    showColumnHeaders?: boolean

    Show/Hide columns headers.

    showFormulas?: boolean

    Indicate if view is showing formulas or values

    showRowGridlines?: boolean

    Show/Hide row gridlines.

    showRowHeaders?: boolean

    Show/Hide row headers.

    showZeros?: boolean

    Indicate whether the sheet should show 0 (zero) or blanks in cells containing zero values.

    When false, cells with zero value appear blank instead of showing the number zero.

    Settings

    Member Visibility

    On This Page

    Properties