Read Sheet of Data
Tue Jul 12 2022 15:08:24 GMT+0000 (Coordinated Universal Time)
Saved by
@Waydes
try {
let ss = SpreadsheetApp.openById(SHEET_ID);
let sheet = ss.getSheetByName(SHEET_NAME);
if (sheet == null) { throw (`Error opening ${SHEET_NAME}`); }
/** Get all data in sheet and convert to objects */
let data = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues();
const header = data.shift();
const objData = getObjects(data, header);
data = null; // Hopefully this triggers some garbage collection
} catch (err) { Logger.log(`ERROR: ${err}`) }
content_copyCOPY
Comments