Script instead of IMPORTRANGE?

S

Sega6662019-05-01 23:51:00

Google Sheets

Sega666, 2019-05-01 23:51:00

Good day.
Please tell me the script that will replace IMPORTRANGE from sheet 1 range A5: P25

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

Noir, 2019-05-02
@PolarBearGG

You just need to use SpreadsheetApp.openById and then get the required sheet and range.
Please see the range.getValues() and range.setValues() documentation.
https://developers.google.com/apps-script/referenc...