| sidebar_label | deleteRow() |
|---|---|
| title | deleteRow method |
| description | You can learn about the deleteRow method in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet. |
@short: Removes a row from the spreadsheet
:::info The method finds the specified cell, selects it, removes the row where the cell is located and moves the row below to its position. :::
deleteRow(cell: string): void;cell- (required) the id of a cell that contains the id of a row that should be deleted
const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);
// removes the second row
spreadsheet.deleteRow("G2");:::note You can delete several rows by providing a range of cells' ids as a parameter of the method, e.g.: "A1:C3". :::
Related articles: Work with Spreadsheet