Skip to content
This repository was archived by the owner on May 30, 2021. It is now read-only.

Dynamically adding data

Karl edited this page Sep 1, 2017 · 26 revisions

New data of many formats can be added at any time with the insert() and import() methods as well as the rows() and columns() API.


You can quickly add a new row with an array of cell data:

var newRow = ["Cell 1", "Cell 2", "Cell 3", "Cell 4", ...];

datatable.rows().add(newRow);

The add() method also accepts a nested array for adding multiple rows:

var newRows = [
    ["Cell 1", "Cell 2", "Cell 3", "Cell 4", ...],
    ["Cell 1", "Cell 2", "Cell 3", "Cell 4", ...],
    ["Cell 1", "Cell 2", "Cell 3", "Cell 4", ...],
    ["Cell 1", "Cell 2", "Cell 3", "Cell 4", ...],
    ...
];

datatable.rows().add(newRows);

Nested JSON strings can easily be imported:

"[{
    'Heading 1': 'Value 1',
    'Heading 2': 'Value 2',
    'Heading 3': 'Value 3',
    ...
},
{
    'Heading 1': 'Value 4',
    'Heading 2': 'Value 5',
    'Heading 3': 'Value 6',
    ...
}]"
datatable.import({
    type: "json",
    data: // the above JSON string
});

Clone this wiki locally