I want to delete a row from my sheet via Apps Script. I've been searching for answers. The documentation here uses getActiveSpreadsheet()
method, but it always returns null
to me. I don't understand how 'active spreadsheet' and 'non-active spreadsheet' work. Is there any way that I can get my spreadsheet by ID instead? Or do you have any other solution? I read in some parts that there is 'bound script' but I don't know how it works.
P.S. I used to use these methods to append and update my sheet. Could have it been expired so that I can't find the official documentation?
Sheets.Spreadsheets.Values.append(resource,spreadsheetId,range,optionalArgs);
Sheets.Spreadsheets.Values.update(resource,spreadsheetId,range,optionalArgs);
This will delete the first row.
SpreadsheetApp.openById('Id').getSheetByName('SheetName').deleteRow(1);