easy-spreadsheet-write
    Preparing search index...

    Interface WorkSheet

    Worksheet Object

    interface WorkSheet {
        "!autofilter"?: AutoFilterInfo;
        "!cols"?: ColInfo[];
        "!data"?: CellObject[][];
        "!margins"?: MarginInfo;
        "!merges"?: Range[];
        "!protect"?: ProtectInfo;
        "!ref"?: string;
        "!rows"?: RowInfo[];
        "!type"?: SheetType;
        [cell: string]: any;
    }

    Hierarchy

    • Sheet
      • WorkSheet

    Indexable

    • [cell: string]: any

      Indexing with a cell address string maps to a cell object Special keys start with '!'

    Index

    Properties

    !autofilter? !cols? !data? !margins? !merges? !protect? !ref? !rows? !type?

    Properties

    "!autofilter"?: AutoFilterInfo

    AutoFilter info

    "!cols"?: ColInfo[]

    Column Info

    "!data"?: CellObject[][]

    Dense-mode worksheets store data in an array of arrays

    Cells are accessed with sheet['!data'][R][C] (where R and C are 0-indexed)

    "!margins"?: MarginInfo

    Page Margins

    "!merges"?: Range[]

    Merge Ranges

    "!protect"?: ProtectInfo

    Worksheet Protection info

    "!ref"?: string

    Sheet Range (A1-style)

    "!rows"?: RowInfo[]

    Row Info

    "!type"?: SheetType

    Sheet type

    Settings

    Member Visibility

    On This Page

    Properties