Search code examples
pygsheets

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.

Solution

  • 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}')