1

I have a google sheets workbook whose sheets get continuously re-ordered. I am able to read each sheet using wks = gc.open("DatSheet").sheet1, but this will always get data from the sheet in first position. How can i use individual sheet names to access them, for example: wks = gc.open("DatSheet").uniquename?

Vaibhav Vishal
  • 6,576
  • 7
  • 27
  • 48
Alvin Wanda
  • 179
  • 2
  • 9

1 Answers1

2

You can use the worksheet function to get a worksheet based on title, index or id. Or you can just use worksheet_by_title.

So in your case 

gc.open("DatSheet").worksheet_by_title("sheet name")
Nithin
  • 5,470
  • 37
  • 44