Database Reference
In-Depth Information
// erase your query!
throw new Error("Cannot write query results to
active sheet");
}
if (sheet) {
sheet.clear();
} else {
sheet = spreadsheet.insertSheet(sheetName);
}
return sheet;
}
/**
* Gets a function that can be used to write out
chunks of
* data as they're being returned from BigQuery.
*/
function getChunkWriter(sheetName) {
return function(rowIndex, rows) {
var sheet;
if (rowIndex == 1) {
// If we're starting from the beginning, we need
to set up
// the result sheet.
sheet = setUpResultSheet(sheetName);
} else {
// The sheet should already exist and be ready
for us to write.
sheet =
SpreadsheetApp.getActive().getSheetByName(sheetName);
}
writeChunk(sheet, rowIndex, rows);
return rowIndex + rows.length;
}
}
/**
