The delRow function is established to delete rows in a sheet.
var excel = new Excel("test.xlsx");
excel.delRow("mySheet,0);
excel.delRow("mySheet,1,10);| Calling | Returning |
|---|---|
| Excel . delRow ( sheetName , startRow) | Excel |
| Excel . delRow ( sheetName , startRow , n) | Excel |
| Parameters | Type | Description |
|---|---|---|
| sheetName | String | The sheet name. |
| startRow | Number | The row index where rows will be deleted from it. Indexed from 0. |
| n | Number | The row count to be deleted. The default value is 1. |