0

I have worksheet with 2 sheets and Need to share it on team Drive. I read the documentation on pyghsheet ,In share pygsheet.share method we can pass group/user , But how can we share on a teamDrive.

gc= pygsheets.authorize(outh_nonlocal=True)
gc.enableTeamDriveSupport = True

gc.teamDriveId = "xxxxxxxxxxxxx"
print " aurhorization done"
sheet= gc.create("Price-"+oldDate)
sheet.add_worksheet("Sheet2",rows=1000,cols=15)
workSheet=sheet[0]
workSheet.set_dataframe(finalPrice,(1,1))
workSheet=sheet[1]
workSheet.set_dataframe(intermediate,(1,1))
sheet.share(??????)

How it can be achieved.

Seema Mudgil
  • 365
  • 1
  • 7
  • 15

1 Answers1

1

As you want to create a sheet on a teamDrive, just specify the id of a folder where you want the sheet to be created

gc= pygsheets.authorize(outh_nonlocal=True)
gc.enableTeamDriveSupport = True

gc.teamDriveId = "xxxxxxxxxxxxx"
print " aurhorization done"
sheet= gc.create("Price-"+oldDate, parent_id="xxxxxxxx") # your folder id as parent
sheet.add_worksheet("Sheet2",rows=1000,cols=15)
workSheet=sheet[0]
workSheet.set_dataframe(finalPrice,(1,1))
workSheet=sheet[1]
workSheet.set_dataframe(intermediate,(1,1))
Nithin
  • 5,470
  • 37
  • 44