Hello,

I have been looking into your question and an approach I could suggest is to mark the worksheet as protected. This could be done via the protect method. More about configuring protection as well as a small demo that you might consider useful could be found in this topic in our documentation.

Let me know if I may be of any further assistance.
Sincerely,
Teodosia Hristodorova
Software Developer

Hello,

I have determined that a method that could be used in order to achieve a similar functionality is the deleteCells method.  It could take as a parameter a particular address or a region to delete.

Let me know if I may be of any further assistance.

Sincerely,
Teodosia Hristodorova
Software Developer

Hello,

A possible approach using the deleteCells method would be to create a WorksheetRegion with all cells in the required rows and pass this region as a parameter of the method as follows:

  public delete() {
    const ws = this.spreadsheet.workbook.worksheets(0);
    const maxColIndex = ws.columns().maxCount - 1;
    let region = new WorksheetRegion(ws, 0, 0, 1, maxColIndex);
    ws.deleteCells(region, false);
  }

In addition, please note that according to our policy, we handle a single issue per case, and since the inial topic was about non-editable worksheets, my suggestion, if you have further questions not related to the initial, is to create new threads. This is for better consistency and history tracking.

If you require any further assistance on the matter, please let me know.

Sincerely,
Teodosia Hristodorova
Software Developer