How to delete data?

I want to remove all data checks from the sheet, tried to follow, but he does not get rid of them. Anyway, to do this through a script application?

var ss = SpreadsheetApp.getActiveSpreadsheet(); var accountSheet = ss.getSheetByName("Account A"); accountSheet.getRange(1,1,274,61).clear(); 
+6
source share
1 answer
 accountSheet.getRange(1,1,274,61).setDataValidation(null) 

That should do the job.

+7
source

Source: https://habr.com/ru/post/1242607/


All Articles