Google Apps脚本,选择一个工作表-在第一个工作表标签中设置值-而不是特定的工作表标签 [英] Google Apps Script, select a sheet - Sets values in first sheet tab - not a specific sheet tab
问题描述
提供的脚本似乎可以正常工作,但是当我希望将数据发布到标题为XML的工作表上时,它将数据发布到电子表格的第一个工作表标签中.
The script provided seems to work, but it posts the data to the first sheet tab of the spreadsheet, when I'd like to have it post on a sheet entitled XML.
我尝试将 getActiveSheet()
更改为 getSheetByName("XML")
以及其他一些方法,但是都没有运气.有什么想法吗?
I've tried changing getActiveSheet()
to getSheetByName("XML")
and a number of other things but have had no luck. Any ideas?
function getData() {
var queryString = Math.random();
var cellFunction1 = '=IMPORTXML("http://www.resources-game.ch/exchange/kurseliste.xml?' + queryString + '","//RESOURCES_RATES/ITEM")';
SpreadsheetApp.getActiveSheet().getRange('A1').setValue(cellFunction1);
}
推荐答案
更改此行:
SpreadsheetApp.getActiveSheet().getRange('A1').setValue(cellFunction1);
对此:
SpreadsheetApp.getActiveSpreadsheet()
.getSheetByName('XML').getRange('A1')
.setValue(cellFunction1);
我添加了与 getActiveSheet()
不同的 getActiveSpreadsheet()
.还有一个 getActive()
方法可获取电子表格.因此, getActive()
和 getActiveSpreadsheet()
都做相同的事情.他们得到电子表格,而不是工作表.我之前已经混淆了这三种方法.
I added getActiveSpreadsheet()
which is different than getActiveSheet()
. There is also a getActive()
method which gets a spreadsheet. So, both getActive()
and getActiveSpreadsheet()
do the same thing. They get the spreadsheet, not a sheet. I've confused those 3 methods before.
-
getActive()
-获取电子表格 -
getActiveSpreadsheet()
-获取电子表格 -
getActiveSheet()
-获取 sheet
getActive()
- gets spreadsheetgetActiveSpreadsheet()
- gets spreadsheetgetActiveSheet()
- gets sheet
这篇关于Google Apps脚本,选择一个工作表-在第一个工作表标签中设置值-而不是特定的工作表标签的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!