所以我希望我的程序在我的谷歌表格的第一列中搜索一個元素,如果找到該元素,則返回相應的行。當我測試此代碼時,即使該元素存在,也顯示它不存在。function doGet(e){ var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1AssaPoFPcazneN44EjE04fE99MxTaPZg5uMsO1Klh4o/edit#gid=0"); var sheet = ss.getSheetByName("Sheet1"); return finds(e,sheet);}function doPost(e){ var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1AssaPoFPcazneN44EjE04fE99MxTaPZg5uMsO1Klh4o/edit#gid=0"); var sheet = ss.getSheetByName("Sheet1"); return finds(e,sheet); }function finds(e,sheet) { var records = {}; var scannedData = e.parameter.sdata; var range = sheet.getDataRange().getDisplayValues().map(r => r[0]); // -> get display Data as 1D array - Col A var data = []; if(range.includes(scannedData)) { // use includes to see if scannedData is included in the array var row_scannedData = range.indexOf(scannedData); var result = sheet.getRange(row_scannedData,1,1,4); //fetches the entire row belonging to the result data.push(result); //pushes the row in an array records.items = data; var finalresult = JSON.stringify(records); return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON); } return ContentService.createTextOutput("Not Found").setMimeType(ContentService.MimeType.TEXT);}
Google Apps 腳本:查找列中的元素并返回相應的行
守著星空守著你
2023-07-06 16:37:53