New_sheet = sheet.get_worksheet(sheet_page) # get the instance of the second sheet,for the first sheet, pass the index 0 and so on. Sheet.add_worksheet(rows=row,cols=col,title=title) # title of new data ![]() Create a function to upload an updated data to your Google Sheets on a new sheetĭef upload_data_to_gs(title,sheet_page,updated_df):. ![]() Records_data = sheet_instance.get_all_records() #For the first sheet, pass the index 0 and so on. # extract data from google sheet by the name of the sheet ![]() Gc = rvice_account(filename=creds_file) # gspread – to interact with Google Spreadsheets # obtain the client email and the data from google sheet with dataframe type
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |