获取行中的选定值 [英] Get selected values in row

问题描述

我希望能够选择一行并获取其中的值.我有:

var id = ' ------gkqlDoUg'

 var sheet =    SpreadsheetApp.openById(id).getSheetByName('mysheeet')
 var vals= sheet.getActiveRange().getValues();

 Logger.log(vals)

运行此命令时没有错误，但我看到了

[20-08-08 13:08:17:834 PDT] [[ ]]

我该如何工作?

解决方案

出了点问题，可能是错误，但这随机失败.无论如何，这里是一个有关如何获得工作"的超简单演示

1. 创建电子表格
2. 在行中添加一些值
3. 选择行
4. 将以下脚本绑定到上一个电子表格的有界项目

   function myFunction() {
     var values = SpreadsheetApp.getActiveRange().getValues();
     Logger.log(values);
   }
   

5. 授权脚本
6. 运行功能.

[20-08-08 15:58:57:727 CDT] [[adfa, afdfafs, dasfasf, , , , , , , , , , , , , , , , , , , , , , , ]]

---

我认为存在与getActiveRange()使用链接有关的错误.

这有时无法获得预期的结果

function myFunction2(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var values = sheet.getActiveRange().getValues();
  Logger.log(values);
}

注意:以下快照是从脚本的执行页面获取的.

失败

成功

这将获得预期的结果

function myFunction3(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var range = sheet.getActiveRange();
  var values = range.getValues();
  Logger.log(values);
}

相关

以下是使用类表getActiveRange()与某些类范围方法(例如getRow()，getValues())链接在一起的问题，但是当前答案没有提及问题的原因，它们只是提供了替代代码

• 在一天中的特定时间通过电子表格发送数据
• 将行和列数据转换为仅列
• 尝试从另一个标签复制值，但始终出现错误函数getValues()不能用作左侧" ;

I want to be able to select a row and get the values in it. I have:

var id = ' ------gkqlDoUg'

 var sheet =    SpreadsheetApp.openById(id).getSheetByName('mysheeet')
 var vals= sheet.getActiveRange().getValues();

 Logger.log(vals)

when I run this there are no errors but I see:

[20-08-08 13:08:17:834 PDT] [[ ]]

How can I get this working?

解决方案

There is something wrong, maybe a bug, but this fails randomly. Anyway here is a super simple demo of about "how to get this working"

1. Create a spreadsheet
2. Add some values to a row
3. Select the row
4. The following script to a bounded project to the previous spreadsheet

   function myFunction() {
     var values = SpreadsheetApp.getActiveRange().getValues();
     Logger.log(values);
   }
   

5. Authorize the script
6. Run the function.

[20-08-08 15:58:57:727 CDT] [[adfa, afdfafs, dasfasf, , , , , , , , , , , , , , , , , , , , , , , ]]

---

I think that there is a bug related to use chaining with getActiveRange().

This sometime fails to get the expected result

function myFunction2(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var values = sheet.getActiveRange().getValues();
  Logger.log(values);
}

NOTE: The following snapshots were taken from the script's executions page.

Failed

Succeded

This gets the expected result

function myFunction3(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var range = sheet.getActiveRange();
  var values = range.getValues();
  Logger.log(values);
}

Related

The following are questions that uses Class Sheet getActiveRange() chained with some Class Range methods like getRow(), getValues() but the current answers doesn't mention the cause of the problem, they just offer an alternative code

• Emailing data from a spreadsheet at a specific time of day
• Convert row and column data to column-only
• Trying to copy values from another tab but keep getting error "function getValues() can not be used as the left-hand side"

这篇关于获取行中的选定值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！