javascript - Copy 2D array to another sheet -
i want re-create values of cells several 2d array, in middle of final sheet( generated functions, help of several sheet contains info ) sheet give info after execution of funcions avoid crushing data, because didnt found solution my lastly questions .
thanks help.
not quite sure if after found on google developers site:
var ss = spreadsheetapp.getactivespreadsheet(); var source = ss.getsheets()[0]; var destination = ss.getsheets()[1]; var range = source.getrange("b2:d4"); // copies info in b2:d4 in source sheet // d4:f6 in sec sheet range.copyvaluestorange(destination, 4, 6, 4, 6); https://developers.google.com/apps-script/reference/spreadsheet/range#copyvaluestorange(sheet,integer,integer,integer,integer)
hope helps.
javascript google-apps-script google-spreadsheet
No comments:
Post a Comment