SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface JSON

    JSON representation of an ISheet used for serialization and deserialization.

    interface JSON {
        autoTable?: JSONReference<ITable.JSON>;
        codeName?: string;
        cols?: JSONReference<ICellHeader.JSON>[];
        comments?: JSONReference<IComment.JSON>[];
        conditionalFormatCalculation?: boolean;
        conditionals?: JSONReference<IConditionalFormat.JSON>[];
        data?: GridTuple<ICell.JSON>;
        defaultColSize?: number;
        defaultRowSize?: number;
        directStyles?: JSONReferenceTuple<number>[];
        entireSize?: Partial<Size>;
        formulaArray?: JSONReferenceTuple<FormulaArrayKind>[];
        formulas?: JSONReferenceTuple<string>[];
        hyperlinks?: JSONReference<IHyperlink.JSON>[];
        legacyDrawing?: LegacyDrawingJSON;
        legacyDrawingHF?: LegacyDrawingJSON;
        merges?: Address[];
        modules?: Record<string, CompiledModule>;
        movables?: IMovable.JSON<any>[];
        outline?: IOutline.JSON;
        pageMargins?: Partial<PageMargin>;
        picture?: IPicture.JSON;
        pivotTables?: IPivotTable.JSON[];
        protectedRanges?: JSONReference<IProtectedRange.JSON>[];
        protection?: ISheetProtection.JSON;
        resources?: IResource.JSON[];
        rows?: JSONReference<ICellHeader.JSON>[];
        slicers?: Record<string, ISlicer.JSON>;
        strings?: string[];
        styles?: IStyleCollection.JSON;
        tabColor?: string;
        tables?: JSONReference<ITable.JSON>[];
        validations?: JSONReference<IDataValidation.JSON>[];
        view?: ISheetView.JSON;
        volatile?: Address[];
    }
    Index
    autoTable? codeName? cols? comments? conditionalFormatCalculation? conditionals? data? defaultColSize? defaultRowSize? directStyles? entireSize? formulaArray? formulas? hyperlinks? legacyDrawing? legacyDrawingHF? merges? modules? movables? outline? pageMargins? picture? pivotTables? protectedRanges? protection? resources? rows? slicers? strings? styles? tabColor? tables? validations? view? volatile?
    autoTable?: JSONReference<ITable.JSON>
    codeName?: string

    The sheet's VBA code name. Absent when it has none.

    ISheet.getCodeName

    cols?: JSONReference<ICellHeader.JSON>[]

    Column headers, each addressed as an entire-column run ('E:E', 'E:H').

    Can be empty. The address carries the orientation, so a row address is read here too.

    comments?: JSONReference<IComment.JSON>[]

    The comments and notes, one per cell, each thread with its replies.

    ISheet.getComments

    conditionalFormatCalculation?: boolean

    Present, as false, only when conditional format calculation is turned off.

    ISheet.isConditionalFormatCalculationEnabled

    conditionals?: JSONReference<IConditionalFormat.JSON>[]
    data?: GridTuple<ICell.JSON>
    defaultColSize?: number
    defaultRowSize?: number
    directStyles?: JSONReferenceTuple<number>[]

    Either an object with RangeAddress to style id or an array of RangeCoordValue to style id.

    entireSize?: Partial<Size>

    If specified this indicates the entire range of the sheet.

    formulaArray?: JSONReferenceTuple<FormulaArrayKind>[]

    The extent occupied by an array formula, and which of the three kinds of array formula it is.

    Every array formula earns an entry, degenerate 1x1 ones included - a 1x1 extent is not the same thing as no extent. Only the kind distinguishes a fixed one-cell block from a dynamic formula that happened not to spill; the extent cannot.

    formulas?: JSONReferenceTuple<string>[]
    hyperlinks?: JSONReference<IHyperlink.JSON>[]
    legacyDrawing?: LegacyDrawingJSON

    The sheet's legacy drawing: note boxes and form control shapes.

    ISheet.LegacyDrawingJSON

    legacyDrawingHF?: LegacyDrawingJSON

    The legacy drawing for the sheet's header and footer, which holds their pictures.

    ISheet.LegacyDrawingJSON

    merges?: Address[]
    modules?: Record<string, CompiledModule>

    Modules owned by this sheet, keyed by module name.

    ISheet.getModules

    movables?: IMovable.JSON<any>[]
    outline?: IOutline.JSON

    The outline settings that differ from their defaults.

    ISheet.getOutline

    pageMargins?: Partial<PageMargin>
    picture?: IPicture.JSON

    The sheet's picture.

    pivotTables?: IPivotTable.JSON[]

    The sheet's pivot tables.

    ISheet.getPivotTables

    protectedRanges?: JSONReference<IProtectedRange.JSON>[]
    protection?: ISheetProtection.JSON
    resources?: IResource.JSON[]
    rows?: JSONReference<ICellHeader.JSON>[]

    Row headers, each addressed as an entire-row run ('5:5', '5:12').

    Can be empty. The address carries the orientation, so a column address is read here too.

    slicers?: Record<string, ISlicer.JSON>
    strings?: string[]
    styles?: IStyleCollection.JSON
    tabColor?: string
    tables?: JSONReference<ITable.JSON>[]
    validations?: JSONReference<IDataValidation.JSON>[]
    view?: ISheetView.JSON
    volatile?: Address[]

    Settings
    Member Visibility

    On This Page
    Properties