代碼很好，沒有發現錯誤，但是檔案夾非常重（充滿檔案），所以運行時（執行）是無限的，我有這個作為評論
JavaScript 運行時意外退出。
我的目標是復制每個檔案的范圍“D12：T64”并將其合并到主檔案“Extract1”
function ExtractPPS1(){
var folder = DriveApp.getFolderById("1tCw6VpQN7ccaiIDTEm7hsJ8ZKw50MDJ6");
var filesIterator = folder.getFiles();
var file;
var fileType;
var ssID;
var combinedData= [];
var data;
while(filesIterator.hasNext()){
file = filesIterator.next();
fileType = file.getMimeType();
if (fileType ==="application/vnd.google-apps.spreadsheet" ){
ssID = file.getId();
data = getDataFromAssessment1(ssID);
combinedData = combinedData.concat(data);
}
}
var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Extract1");
ws.getRange("D12:T64").clearContent();
ws.getRange(2,1,combinedData.length, combinedData[0].length).setValues(combinedData);
ws.getRange()
}
function getDataFromAssessment1(ssID){
var ss = SpreadsheetApp.openById(ssID);
var ws = ss.getSheetByName("Assessment Sheet ORCA Pilot STEP1");
var data = ws.getRange("D12:T64" ws.getLastRow()).getValues();
return data;
};
uj5u.com熱心網友回復：
function ExtractPPS1() {
var csh = SpreadsheetApp.getActive.getSheetByName("Extract1");
csh.getRange("D12:T64").clearContent();
var folder = DriveApp.getFolderById("ssid");
var files = folder.getFiles();
while (files.hasNext()) {
let file = files.next();
if (file.getMimeType() == "application/vnd.google-apps.spreadsheet") {
var ss = SpreadsheetApp.openById(file.getId());
var sh1 = ss.getSheetByName("Assessment Sheet ORCA Pilot STEP1");
var vs1 = sh1.getRange("D12:T64").getValues();
csh.getRange(csh.getLastRow() 1, 1, vs1.length, vs1[0].length).setValues(vs1);
}
}
}
將檔案名添加到資料集：
function ExtractPPS1() {
var csh = SpreadsheetApp.getActive.getSheetByName("Extract1");
csh.getRange("D12:T64").clearContent();
var folder = DriveApp.getFolderById("ssid");
var files = folder.getFiles();
while (files.hasNext()) {
let file = files.next();
if (file.getMimeType() == "application/vnd.google-apps.spreadsheet") {
var ss = SpreadsheetApp.openById(file.getId());
var sh1 = ss.getSheetByName("Assessment Sheet ORCA Pilot STEP1");
var vs1 = sh1.getRange("D12:T64").getValues();
vs1.unshift([...Array.from(new Array(vs1[0].length).keys(),x => (x == 0) ? `File Name: ${file.getName()}`:'')])
csh.getRange(csh.getLastRow() 1, 1, vs1.length, vs1[0].length).setValues(vs1);
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/512526.html