问将数组写入电子表格

EN

function transferResponses() {
// establish sheets
  var aFile = SpreadsheetApp.getActiveSpreadsheet();
  var aResponseSh = aFile.getSheetByName("Form responses 1");
  var aBaseSh = aFile.getSheetByName("Base");

// check number of response
  var numResponses = aResponseSh.getLastRow() - 1;
// put responses in an array
  var aResponses = aResponseSh.getSheetValues(2, 1, numResponses, 23);

// define other variables to use
  var oneEntry = [];      // array for a single entry
  var aEntries = [];      // array of all entries
  var aNumber;            // increment part of ID

// counters, etc
  var iRes;
  var iCol;
  var iEntry = 0;

  for (iRes = 0; iRes < numResponses; iRes++) {    
    aNumber = iEntry + 101;
    oneEntry[0] = "A" + aNumber.toString();        // form and load entry ID
    for (iCol = 1; iCol < 12; iCol++) {            // load name, surname, address 1, address 2,     phone, email
      oneEntry[iCol] = aResponses[iRes][iCol];     //   and first entry title, classification,     size, description, price
    }
    oneEntry[12] = aResponses[iRes][18];           // load novice status
    oneEntry[13] = aResponses[iRes][21];           // load date of entry
    oneEntry[14] = aResponses[iRes][22];           // load method of payment

    aEntries.push(oneEntry.valueOf());             // push entry (oneEntry) into main aray     (aEntries)

    iEntry = iEntry + 1;                           // increment single entry counter

    if (aResponses[iRes][12] === "Add another entry") {     // check for a second entry on     response
      aNumber = iEntry + 101;
      oneEntry[0] = "A" + aNumber.toString();        // form and load entry ID
      for (iCol = 1; iCol < 7; iCol++) {             // load name, surname, address 1, address 2,     phone, email
        oneEntry[iCol] = aResponses[iRes][iCol];     //   and first entry title, classification,     size, description, price
      }
      for (iCol = 7; iCol < 12; iCol++) {            //   and second entry title, classification,     size, description, price
        oneEntry[iCol] = aResponses[iRes][iCol + 6];
      }
      oneEntry[12] = aResponses[iRes][18];           // load novice status
      oneEntry[13] = aResponses[iRes][21];           // load date of entry
      oneEntry[14] = aResponses[iRes][22];           // load method of payment

      aEntries.push(oneEntry.valueOf());             // push entry (oneEntry) into main aray     (aEntries)

      iEntry = iEntry + 1;                           // increment single entry counter
    }
  } 

  lastRow = aBaseSh.getLastRow();
  if (lastRow > 1) {                             // clear all existing data on base sheet
    aBaseSh.deleteRows(2, lastRow);
  }

  aBaseSh.getRange(2, 1, aEntries.length, aEntries[0].length).setValues(aEntries);    // paste     main array (aEntries)

}