I am trying to modify data in a spreadsheet based on the data entered in another spreadsheet. To access the data within the sheet i can use the SpreadsheetApp.getActiveSpreadsheet(); function but how to reference another spreadsheet from there?
To reference another spreadsheet you need to find its Id
Look at the URL
https://docs.google.com/spreadsheets/d/THIS IS THE ID/edit#gid=0
copy the Id from the URL
In the sheet that you want to read this from create a reference by using this
var othersheet = SpreadsheetApp.openById("PUT THE ID IN HERE");
Now when you use othersheet you can access anything onit., assuming you have permission
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다