Skip to content

Instantly share code, notes, and snippets.

@bran921007
Forked from beezly/gist:4250079
Created October 12, 2019 11:06
Show Gist options
  • Save bran921007/df7a43d49dc976dec7535b44a1bea625 to your computer and use it in GitHub Desktop.
Save bran921007/df7a43d49dc976dec7535b44a1bea625 to your computer and use it in GitHub Desktop.
Google Script Spreadsheet function to iterate over all cells and insert the value 0 if the cell is blank
function zeroCells() {
var ss=SpreadsheetApp.getActiveSpreadsheet();
var sheet=ss.getSheets()[0];
var selection=sheet.getDataRange();
var columns=selection.getNumColumns();
var rows=selection.getNumRows();
for (var column=1; column < columns; column++) {
for (var row=1; row < rows; row++) {
var cell=selection.getCell(row,column);
if (cell.isBlank()) {
cell.setValue(0);
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment