Monday, 15 August 2011

javascript - Copy 2D array to another sheet -



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