不能似乎从我的脚本中的另一个谷歌电子表格中读取单元格数据 [英] Cant seem to read cell data from another google spreadsheet in my script
问题描述
这是我的剧本。它返回文件夹我的文件夹中每个工作表的url,但不返回我所要求的单元格值。任何人都可以看到什么是错的?我已检查过电子表格,以确保引用的单元格中有值。
`function onOpen(){
var folder = DocsList.getFolder(My folder);
var contents = folder.getFiles();
This is my script. It returns the url for each sheet in the folder "My folder", but returns no cell value that I am asking for. Can anyone see what is wrong? I have checked the spreadsheets to make sure there are values in the cells referenced.
`function onOpen() {
var folder = DocsList.getFolder("My folder");
var contents = folder.getFiles();
var file;
var data;
var sheet = SpreadsheetApp.getActiveSheet();
sheet.clearContents();
sheet.appendRow(["link to sheet", "Name", "Type", "Primary Contact"]);
for (var i = 0; i < contents.length; i++) {
file = contents[i];
var cellValue;
if (file.getFileType() === "SPREADSHEET") {
var sheet = SpreadsheetApp.openById(file.getId()).getSheetByName("Site Demographics");
var value1 = sheet.getRange('B7').getValue();
var value2 = sheet.getRange('C7').getValue();
var value3 = sheet.getRange('H9').getValue();
cellValue = ""+value1 + value2 + value3;
} else {
cellValue = null; // No Data
}
data = [ file.getUrl(),cellValue ]
sheet.appendRow(data);
}
};`
推荐答案
看来你应该检查一个文件是否是给定类型的文件。
It seems that you should check if a file is of a given type by doing this
if (file.getFileType()==DocsList.FileType.SPREADSHEET)
另外,您正在重用变量表
。考虑将它的第二个用法重命名为 otherSheet
。
Also, you are reusing the variable sheet
. Consider renaming the second usage of it to otherSheet
.
这篇关于不能似乎从我的脚本中的另一个谷歌电子表格中读取单元格数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!