如何从电子表格加载特定表格 [英] How load a specific sheet from a Spreadsheet

问题描述

我有一个包含大量表单的电子表格，我需要在脚本中加载其中一张表格，我该怎么做？

这里是一个我的电子表格中的图纸照片

这里是我的想法如何做到这一点

  var sheet = SpreadsheetApp.openById（index）.getSheetByName（'Geraçãode DEMANDA'）; 
  

是吗？

谢谢。

解决方案

你几乎在那里...你想要的是让这张表活跃，所以试试这个： p>

  var sheet = SpreadsheetApp.getActiveSpreadsheet（）; 
 SpreadsheetApp.setActiveSheet（sheet.getSheetByName（'Geraçãode Demanda'））
  

I have a Spreadsheet that contains a lot of sheets, and i need to load one of these sheets in my script, how i do that?

here is a photo of the sheets in my Spreadsheet

here is my idea how to do it

var sheet = SpreadsheetApp.openById(index).getSheetByName('Geração de Demanda');

is that?

Thank you.

解决方案

You're almost there... what you want is to make that sheet 'active' so try this :

var sheet = SpreadsheetApp.getActiveSpreadsheet();
SpreadsheetApp.setActiveSheet(sheet.getSheetByName('Geração de Demanda'))

这篇关于如何从电子表格加载特定表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！