CODEWITHSUNDEEP
pygsheets
Kevin Nash
Kevin Nash

Reputation: 1561

How to insert Dataframe into Google Sheet dynamically using pygsheet

I am trying to insert a number of Dataframes into google spreadsheet. I am using the pygsheets module.

I have a variable that the stores the row number in a loop. I am trying to have the Dataframe inserted in the corresponding cell reference. I am doing as per below but I see the Dataframe gets overwritten in the same cell as it runs through a loop

sheet.set_dataframe(df, 'A' + '1 + x')

My expectations are to insert in the below 3 Dataframes starting from cells A6, A11, A16 respectively. Currently x has a value of 5 and it changes to 10 and 15 respectively as part of the loop.

Upvotes: 0

Views: 665

Answers (2)

Nithin
Nithin

Reputation: 5840

I dont understand why you are not substituting for x. anyway this will do what you want in py3

sheet.set_dataframe(df, f'A{1+x}')

Upvotes: 2

Piyush Kumar
Piyush Kumar

Reputation: 122

You can try like this:-

sheet.set_dataframe(df, ('A' + '1 + x'))

I hope this works for you.

Upvotes: 0

Related Questions