Answers for "get active spreadsheet and sheet data"

Whatever

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"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#