Answers for "get active spreadsheet and sheet data"

0

get active spreadsheet and sheet data

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet_1 = ss.getSheets()[0];
var sheet_2  = ss.getSheets()[1];
var sheet_1_data = sheet_1.getDataRange().getValues();
var sheet_2_data = sheet_2.getDataRange().getValues();
Posted by: Guest on May-21-2021

Code answers related to "get active spreadsheet and sheet data"

Browse Popular Code Answers by Language