在特定工作表上运行的脚本 [英] Script to run on specific sheet

问题描述

我有一个正在使用的脚本，但该脚本只能与活动工作表一起使用(从Google云端硬盘中的指定目录中拉出文档列表).如何将其转换为在特定工作表上运行.工作表的名称为每7".

I have a script that I have been using, but it only works with, as written, the active sheet (pulls a list of documents from the specified directory in Google Drive). How can transform this to run on a specific sheet. The name of the sheet is "Per 7".

function list_all_files_inside_one_folder_without_subfolders(){
  var sh = SpreadsheetApp.getActiveSheet();
  var folder = DriveApp.getFolderById('0B4zzmqQYDRm2flZPRFVWd1FfSGpJTXFmcWlSLXVVTUZJRjNlU3QzTER6aHFsYVEzTDdrS00'); // I change the folder ID  here 
  var list = [];
  list.push(['Name']);
  var files = folder.getFiles();
  while (files.hasNext()){
    file = files.next();
    var row = []
    row.push(file.getName())
    list.push(row);
  }
   sh.getRange(1,1,list.length,list[0].length).setValues(list);
}

推荐答案

尝试更改:

 var sh = SpreadsheetApp.getActiveSheet();

到

 var sh = SpreadsheetApp.getActive().getSheetByName('Per 7');

这篇关于在特定工作表上运行的脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！