Wednesday 15 February 2012

google apps script - Max number of cells which can be updated using setValues()? -


In my script, I try to update a large number of cells in a single run using the set well () function But I'm getting "Array can not be converted into an object [] []" error when I reduce the size of the array so cells are updated with no problem. I can not find any information on the boundaries of the setValues ​​() function, so is the size of the array really an issue?

I really do not want to divide my array, so completely using this error is around this error?

  function counter (parts, milestones, wipsheet, ms sheet, magnets) {var msss = spreadsheets app.openbyid (''); Var WIP = Spreadsheets app.OPENBIID (''); Var MSSOI = MSSS.getSheetByName (MSSheet); Var WIPSOI = WIP.getSheetByName (WIPSheet); Var location = 0; Var ms = ''; Var WIPparts = []; (Var i = 0; i & lt; magnets.length; i ++) {if (magnets [i] [3] == 0) {ms = magnets [i] [1] for (var j = 1; j & lt; (for (var l = 0; l & lt; j; l ++) {for (var k = 0; k & lt; parts) (ms == milestones [j-1 ] [0]) .length; k ++) {parts of [2] + = milestone [l] [k + 1];}}} for (j = 0; j and lt; parts. Length ; J ++) {WIPPers [Part [J] [1] -3] = []; WIP [Part [J] [1] -3] [0] = Parts [J] [2];} WIPSOI.getRange (3, magnets [i] [2], WIPPers.line, 1) .setwalls (wippers); for (var k = 0; k   
  WIPSOI.getRange (3, magnets [i] [2], wipespar.lumb, 1) .Setwall WIPparts); For the chain in WIPparts [Lin], with the  

(Lin WipParates) if (! WIPPers [Lin] [cola]) on WIP [Lin] [cola] = ""; WIPSOI.getRange (3, magnets [i] [2], WIPparts.length, WIPparts [0] .length) .setValues ​​(WIPparts);

The first part will end the non-initial arrays, and the second part will end the possibility of the wrong boundary.


No comments:

Post a Comment