在GoogleAppScript中獲取鍵/值對的值

我在 App Script 專案中有兩個檔案：

#Code.gs
function myFunction() {
  ksu = "Kansas State University";
  Logger.log(lgu_map[ksu]);
}

#data.gs
function lgu_map() {
  map["University of Arkansas Pine Bluff"] = "1890";
  map["University of Maryland Eastern Shore"] = "1890";
  map["Virginia State University"] = "1890";
  map["West Virginia State University"] = "1890";
  map["Iowa State University"] = "North Central";
  map["Kansas State University"] = "North Central";
  map["Michigan State University"] = "North Central";
  map["North Dakota State University"] = "North Central";
  map["Ohio State University    North"] = "Central";
}

我想要做的是查詢 data.gs 中的 lgu_map() 函式以回傳值。所以在這種情況下，我想要Logger.log(lgu_map[ksu]);回傳的是North Central.

甚至不確定我是否可以在不實際傳遞引數的情況下呼叫該函式。

任何幫助表示贊賞

uj5u.com熱心網友回復：

試試這個方法：

const myMap = new Map();
myMap.set("University of Arkansas Pine Bluff", "1890");
myMap.set("University of Maryland Eastern Shore", "1890");
myMap.set("Virginia State University", "1890");
myMap.set("West Virginia State University", "1890");
myMap.set("Iowa State University", "North Central");
myMap.set("Kansas State University", "North Central");
myMap.set("Michigan State University", "North Central");
myMap.set("North Dakota State University", "North Central");
myMap.set("Ohio State University    North", "Central");
myMap.get("University of Arkansas Pine Bluff");//1890

• Javascript 地圖

uj5u.com熱心網友回復：

據我所知，您不需要函式或地圖。它可以只是一個普通物件（它應該作為全域變數放置在任何函式之外）：

// code.gs -------------------------------------------------

function myFunction() {
  ksu = "Kansas State University";
  console.log(lgu_map[ksu]);
}

// data.gs -------------------------------------------------

var lgu_map = {

  "University of Arkansas Pine Bluff"    : "1890",
  "University of Maryland Eastern Shore" : "1890",
  "Virginia State University"            : "1890",
  "West Virginia State University"       : "1890",
  "Iowa State University"                : "North Central",
  "Kansas State University"              : "North Central",
  "Michigan State University"            : "North Central",
  "North Dakota State University"        : "North Central",
  "Ohio State University    North"       : "Central",

}

myFunction(); // output --> 'North Central'

uj5u.com熱心網友回復：

謝謝銅，我用來創建地圖的語法似乎是問題所在。我最終還是不得不將密鑰傳遞給函式；不確定有沒有辦法解決這個問題。這是我想要做的完整作業代碼：

#code.gs
function myFunction() {
  ksu = "Kansas State University";
  Logger.log(lgu_map(ksu));
}

#data.gs
function lgu_map(key) {
  const myMap = new Map();
  myMap.set("University of Arkansas Pine Bluff", "1890");
  myMap.set("University of Maryland Eastern Shore", "1890");
  myMap.set("Virginia State University", "1890");
  myMap.set("West Virginia State University", "1890");
  myMap.set("Iowa State University", "North Central");
  myMap.set("Kansas State University", "North Central");
  myMap.set("Michigan State University", "North Central");
  myMap.set("North Dakota State University", "North Central");
  myMap.set("Ohio State University    North", "Central");
  return myMap.get(key);

}

標籤：谷歌应用程序脚本

上一篇：從Google電子表格的下拉串列中選擇多個值并按字母順序列印

下一篇：使用應用程式腳本將MSWord檔案（保存在Drive中）轉換為GoogleDocs