我的連接函數(shù)運行速度極慢，僅 28 行數(shù)據(jù)就需要將近 4 分鐘才能運行，而且我還有其他代碼需要運行，所以我在 Google 表格中達到了最大執(zhí)行時間如果我在 Excel 中運行類似的過程，這可能需要 15-30 秒一切都在內(nèi)存中，我看不出（由于我對 javascript 的了解有限）為什么我的代碼這么慢謝謝包含數(shù)據(jù)的 Google 表格//Sheet Name//Values in Range to be overwritten by Header names//List of Header names//New Header Name 1//New Header Name 2function AsAboveSoBelow_Offers_Asks() { AsAboveSoBelow('Elements', ["I can offer", "I have a ask"], ["Header1","Header2","Header3","Header4","Header5","Header6", "Header7","Header8","Header9","Header10","Header11", "Header12","Header13","Header14"], "Offers", "Asks");} function AsAboveSoBelow(shtName, arrPBV, arrHeaders, newHeader1, newHeader2) {var ss = SpreadsheetApp.getActiveSpreadsheet();var s = ss.getSheetByName(shtName);var LC = s.getLastColumn();var r = s.getDataRange();var v = r.getValues();var start = new Date(); var temp ="";//Dim Avar A = [];for (var i = 0; i < v.length; i++) { A[i] = []; for (var j = 0; j <= arrPBV.length - 1; j++) { A[i][j] = ''; }}for(var e = 0; e <= arrPBV.length - 1; e++) { var search_Term = arrPBV[e];for(var row = 0; row < v.length; row++) { for(var col = 0; col <= arrHeaders.length - 1; col++) { var col2 = HTN(shtName,arrHeaders[col]) var replace_Term = arrHeaders[col]; if(v[row][col2-1].toString().indexOf(search_Term) > -1) { temp = temp + replace_Term + "|" } } //remove trailing pipe A[row][e] = temp.replace(/\|(?=\s*$)/, '') temp = "" } } A[0][0]= newHeader1 A[0][1]= newHeader2 s.getRange(1, v[0].length +1, v.length,A[0].length).setValues(A);var end = new Date();var executiontime = end - start;Logger.log(executiontime);};//Helper functionfunction HTN(shtName,cheader){var headers = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(shtName).getDataRange().getValues().shift();var colindex = headers.indexOf(cheader);return colindex+1;}
連接代碼運行非常緩慢的谷歌腳本
有只小跳蛙
2022-01-13 16:13:38
