CODEWITHSUNDEEP
handsontable
user1077685
user1077685

Reputation:

Custom object array binding?

I've looked through the documentation, but perhaps I've overlooked what I assume to be a straightforward task. Is it possible to provide a custom binding function so that, in an array of objects, each object corresponds to one cell, rather than each object corresponding to a full row? Would this binding maintain the reference to the original object so that the data would change after being modified in the spreadsheet?

For example, I'd want to create the following sheet:

Example spreadsheet

With JSON in this structure:

[
    {
        "name": "USA",
        "year": 2015,
        "sales": 1,
    },
    {
        "name": "USA",
        "year": 2016,
        "sales": 2,
    },
    {
        "name": "USA",
        "year": 2017,
        "sales": 3,
    },
    {
        "name": "Canada",
        "year": 2015,
        "sales": 4,
    },
    {
        "name": "Canada",
        "year": 2016,
        "sales": 5,
    },
    {
        "name": "Canada",
        "year": 2017,
        "sales": 6,
    }
]

Upvotes: 1

Views: 741

Answers (1)

ZekeDroid
ZekeDroid

Reputation: 7209

You should look at the columns definition. In there you can define the data source for each column such that it will iterate through your objects and set the values of each column given the id for that column. And yes, it uses references so if you edit them, your objects get edited as well.

Upvotes: 1

Related Questions