从GDrive导入Google

Question

我试图使用以下代码将最新的Google工作表导入我的主Google工作表：

function sortfiles() {
  const folder = DriveApp.getFolderById("Folderid");
  const files = folder.getFilesByName("Filename");
  let fA = [];
  while (files.hasNext()) {
    let file = files.next();
    fA.push({ id: file.getId(), dv: file.getDateCreated() })
  }
  fA.sort((a, b) => {
    let vA = new Date(a.dv).valueOf();
    let vB = new Date(b.dv).valueOf();
    return vB-vA;
  });
  Logger.log(DriveApp.getFileById(fA[0].id).getBlob().getDataAsString());
}

哪个是排序哪个文件是最新的，但我被困在代码写到我的主表？

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName("Sheet1");
var data = (DriveApp.getFileById(fA[0].id).getBlob().getDataAsString())
var csvData = Utilities.parseCsv(data, ',');

Answer 1

试一试

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName("Sheet1");
var data = (DriveApp.getFileById(fA[0].id).getBlob().getDataAsString())
var csvData = Utilities.parseCsv(data, ',');
sh.getRange(1,1,csvData.length,csvData[0].length).setValues(csvData)

编辑:如果您的文件是google工作表文件

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getSheetByName("Sheet1");
  var data = SpreadsheetApp.openById(fA[0].id).getSheets()[0].getDataRange().getValues();
  sh.getRange(1, 1, data.length, data[0].length).setValues(data);