Database Reference
In-Depth Information
nCols).setValues(data);
Logger.log('Wrote %s rows to: %s', nRows,
sheet.getName());
}
/**
* Translates the .f and .v format of the query
results into
* a 2D array of values.
*/
function extractRows(rows) {
// Append the results.
var data = new Array(rows.length);
for (var i = 0; i < rows.length; i++) {
var cols = rows[i].f;
data[i] = new Array(cols.length);
for (var j = 0; j < cols.length; j++) {
data[i][j] = cols[j].v;
}
}
return data;
}
/**
* Sets up a sheet with a given name which will
contain our
* query results. If the sheet already exists, it will
be cleared.
* If it doesn't exist, we'll create a new one.
*/
function setUpResultSheet(sheetName) {
var spreadsheet = SpreadsheetApp.getActive();
var sheet = spreadsheet.getSheetByName(sheetName);
if (spreadsheet.getActiveSheet().getName() ==
sheetName) {
// Don't run a query from the queryResults sheet
-- this will
