I was doing some analysis and looking to create a graph in my Google Spreadsheet. The data had gaps and I was looking for a quick/easy way to set all empty cells to zero. I found an example after searching that I turned into the following:
function fillBlanks() {
var sheet = SpreadsheetApp.getActiveSheet();
var sheetLR = sheet.getLastRow();
var sheetLC = sheet.getLastColumn();
var range = sheet.getRange(1, 1, sheetLR, sheetLC);
var values = range.getValues();
for (var r = 1; r < sheetLR; r++) {
for (var c = 0; c < sheetLC; c++) {
if(String(values[r][c]).trim() == "") {
values[r][c] = 0;
}
}
}
range.setValues(values);
}
fillBlanks()
Have your spreadsheet open, then run it from App Scripts. Feel free to take, modify and re-use as you see fit.
No comments:
Post a Comment