Skip to content

Latest commit

 

History

History
164 lines (134 loc) · 2.26 KB

MODEL.md

File metadata and controls

164 lines (134 loc) · 2.26 KB

Workbook Model

The workbook and its components define a simple JavaScript Object model which can be accessed and manipulated if desired.

Workbook Model

{
    worksheets: [
        // array of worksheet models
    ]
}

Worksheet Model

{
    // worksheet id (integer>=1)
    id: 1,
    
    // worksheet name
    name: "blort",
    
    // rows
    rows: [
        // array of row models
    ],
    
    // merge ranges
    "merges": [
        "A2:B3"
    ],
    "dimensions": {
        "top": 1,
        "left": 1,
        "bottom": 3,
        "right": 6
    },

    // setting for enable fit to page (default: false)
    fitToPage: false,

    // setting for page
    pageSetup: {
        paperSize: 9, 
        scale: 100, 
        firstPageNumber: 0, 
        fitToWidth: 1, 
        fitToHeight: 1, 
        pageOrder: "downThenOver", 
        orientation: "portrait", // (portrait | landscape)
        usePrinterDefaults: "false",
        blackAndWhite: "false",
        draft: "false",
        cellComments: "none",
        useFirstPageNumber: "false",
        horizontalDpi: 300,
        verticalDpi: 300,
        copies: 1
    },

    // setting for margins
    pageMargins: {
        left: 0.7,
        right:0.7,
        top: 0.75,
        bottom: 0.75,
        header: 0.3,
        footer: 0.3
    }
}

Row Model

{
    // row number
    number: 1,
    cells: [
        // array of cell models
    ],
    
    // min column number
    min: 1,
    
    // maximum column number
    max: 6
}

Cell Models

Null Cell Model

{
    address: "A1",
    type: 0
}

Merge Cell Model

{
    address: "B1",
    type: 1,
    master: "A1"
}

Number Cell Model

{
    address: "B1",
    type: 2,
    value: 5
}

String Cell Model

{
    address: "B1",
    type: 2,
    value: "Hello, World!"
}

Date Cell Model

{
    address: "C1",
    type: 3,
    value: new Date()
}

Formula Cell Model

{
    address: "D1",
    type: 4,
    formula: "A1+A2",
    result: 7
}

Hyperlink Cell Model

{
    "address": "F1",
    "type": 5,
    "text": "www.link.com",
    "hyperlink": "http://www.link.com"
}