我一直试图从我登录的网页中获取特定的数据，并将其绘制到电子表格上，但一开始就卡住了。 这就是我现在看到的代码:

function login(){  
  var payload =
   {
     "Usuario" : "XXXXX",
     "Senha" : "XXXXX",
   };// The actual values of the post variables (like user_session[email]) depends on the site so u need to get it either from the html of the login page or using the developer tools I mentioned.
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
   
  var content = UrlFetchApp.fetch("https://ovoonline.com.br/" , options).getContentText();

  var json = JSON.parse(content);
  var preco = json["???"]
  return preco;
}

这就是我想要得到的：

这是它的XPath:

function login(){  
  var payload =
   {
     "Usuario" : "XXXXX",
     "Senha" : "XXXXX",
   };// The actual values of the post variables (like user_session[email]) depends on the site so u need to get it either from the html of the login page or using the developer tools I mentioned.
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
   
  var content = UrlFetchApp.fetch("https://ovoonline.com.br/" , options).getContentText();

  var json = JSON.parse(content);
  var preco = json["???"]
  return preco;
}

以下是我得到的部分结果日志:

function login(){  
  var payload =
   {
     "Usuario" : "XXXXX",
     "Senha" : "XXXXX",
   };// The actual values of the post variables (like user_session[email]) depends on the site so u need to get it either from the html of the login page or using the developer tools I mentioned.
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
   
  var content = UrlFetchApp.fetch("https://ovoonline.com.br/" , options).getContentText();

  var json = JSON.parse(content);
  var preco = json["???"]
  return preco;
}

感谢您抽出时间！

顺晟科技：

要从表中检索数据，请使用a并将参数传递给它，这样您就可以使用

所以以下代码:

function login(){  
  var payload =
   {
     "Usuario" : "XXXXX",
     "Senha" : "XXXXX",
   };// The actual values of the post variables (like user_session[email]) depends on the site so u need to get it either from the html of the login page or using the developer tools I mentioned.
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
   
  var content = UrlFetchApp.fetch("https://ovoonline.com.br/" , options).getContentText();

  var json = JSON.parse(content);
  var preco = json["???"]
  return preco;
}

应该变成：（在本例中，我将获取AREA DO ASSINANTE的值）

function login(){  
  var payload =
   {
     "Usuario" : "XXXXX",
     "Senha" : "XXXXX",
   };// The actual values of the post variables (like user_session[email]) depends on the site so u need to get it either from the html of the login page or using the developer tools I mentioned.
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
   
  var content = UrlFetchApp.fetch("https://ovoonline.com.br/" , options).getContentText();

  var json = JSON.parse(content);
  var preco = json["???"]
  return preco;
}

对于您的特定值，将td元素值以及元素的属性传递给，并计算出它在DOM中的索引。然后，您可以访问该元素的属性以获取其值，并将其存储在变量下。