simple-datatables

As of v1.4.0, the rows API is implemented and allows access to the table rows for quick manipulation.

As of v4.0.0, rows is a property and not a method on the current instance.

To use the rows API just access under the rows property of the current instance:

let rows = datatable.rows;

You can then chain the following methods.


add(data [array])

Add new row data to the current instance. The data parameter must be an array of strings to be inserted into each of the new row’s cells.

let newRow = ["column1", "column2", "column3", "column4", ...];

dataTable.rows.add(newRow);

Note: Only one row can be added at a time. If you want to add multiple rows simultaneously, do this instead:

let newRows = [
    ["column1", "column2", "column3", "column4", ...],
    ["column1", "column2", "column3", "column4", ...],
    ["column1", "column2", "column3", "column4", ...],
    ["column1", "column2", "column3", "column4", ...],
    ...
];

 dataTable.insert({data: newRows})

remove(select [array|number])

Remove existing rows from the current instance. The select parameter can either be an integer or array of integers representing the row indexes.

let rows = dataTable.rows;

// remove the 6th row
rows.remove(5);

// remove the first 5 rows
rows.remove([0,1,2,3,4]);

Note that the indexes passed to this method should represent the actual index of the row in the data array. The native rowIndex property represents the position of a row in the rendered page and may be different to the index you need to pass to the remove() method.

For example, if you’re trying to remove a row that’s unrendered, the rowIndex property will return -1.

Another example would be if you’re currently on page 5 and you have perPage set to 5 the currently rendered rows have a rowIndex of 0, 1, 2, 3 and 4, respectively, but to remove them you would need to use the indexes 20, 21, 22, 23 and 24, respectively.

let rows = dataTable.rows;

// Switch to page 5
dataTable.page(5);

// WRONG: removes the first 5 rows on page 1
rows.remove([0, 1, 2, 3, 4]);

// CORRECT: removes the 5 currently rendered rows on page 5
rows.remove([20, 21, 22, 23, 24]);

You can quickly access the correct index for the rendered row by grabbing it’s dataset-index property as opposed to the rowIndex property.

// Get the first rendered row
let rowToRemove = dataTable.body.querySelector("tr");

// Remove it
dataTable.rows.remove(parseInt(rowToRemove.dataset.index));