//データ；テキスト
//表示；ダイアログ,シート

function createData() {
  var sheet = SpreadsheetApp.getActiveSheet().getRange(1, 1, 1, 4 );
  var data = ["tData1","tData2","tData3","tData4"];
  var data2 = [["tData1","tData2","tData3","tData4"]];
  createData = [];
  for(var i=0;i<data.length;++i){
      myData = "";
      myData = data[i];
      createData.push(myData);
  }
   Browser.msgBox(createData + "このあとシートに書き込みます");
   sheet.setValues(data2);//A1:D1に"tData1""tData2""tData3""tData4"
   sheet.setValue(data[0][1]);//A1:D1に"tData2"
   sheet.setValue(createData[0]);//A1:D1に"tData1"
   sheet.setValue(createData[3]);//A1:D1に"tData4"
   sheet.setValue(data[i]);//undefined
   sheet.setValue(createData);//エラー；{"tData1","tData2","tData3","tData4"}を一箇所のセルで表示  
}

//シート内のデータを他の場所へ複写する
//A1:A3のデータをC1:C3へ、A6:B7のデータをC6:D7へ

function copyTo(){
 var ss = SpreadsheetApp.getActiveSheet();
 data = ss.getRange(1,1,3,1).getValues();//取得
 ss.getRange(1,3,3,1).setValues(data);//書き込み
  
 data2 = ss.getRange(6,1,2,2).getValues();//取得
 ss.getRange(6,3,2,2).setValues(data2);//書き込み
}