title: How to write an array to Google Spreadsheet?
body: <p>I'm building an Array with integer values and trying to write it to a Google Spreadsheet in one go:</p>
  
  <pre><code>var myArray=new Array();
      for (i=1;i&lt;=100;i++){
        myArray[i]=i;
      };
  
      ss.getRange(8,4,1,100).setValue(myArray);
  </code></pre>
  
  <p>This is writing on the right cells but the content of each cell are:</p>
  
  <pre><code>[0.0, 1.0, 2.0, 3.0, 4.0, 5.0, ...]
  </code></pre>