![]() Retrieve the values from "G7" and "G8" from the XLSX data converted from PDF data. Wks = gc.open_by_key('#') # Please set your Spreadsheet ID. In this modified script, I modified below gc = thorize(credentials) in your script. When above points are reflected to your script, it becomes as follows. Append the retrieved values to the columns "C" and "D" in Google Spreadsheet.Retrieve the values from the columns "C" and "D" and retrieve the last row of the columns "C" and "D".Retrieve the values from "G7" and "G8" from the XLSX data converted from PDF data.In this modification, I would like to propose the following flow. ![]() I thought that in your situation, this might not be required. In your script, the values retrieved from Spreadsheet are converted to the dataframe.You have already been able to get and put values for Google Spreadsheet using Sheets API.And, at 2nd run, you want to put the retrieved values of "G7" and "G8" to the cells "C3" and "D3" of Spreadsheet. For example, at 1st run, you want to put the retrieved values of "G7" and "G8" to the cells "C2" and "D2" of Spreadsheet.You want to append the values to the columns "C" and "D" in the Spreadsheet every run of script.You want to retrieve the values from the cells "G7" and "G8" from 1st tab in the XLSX data converted from a PDF data.I believe your goal and your current situation as follows. This last line does not update column 3 of the google sheet Wb = openpyxl.load_workbook('dados.xlsx') Wks = gc.open_by_key('1AGYhinoPiE9xUABnrNEfVGjLf5s_bAJGjpz9hatfIQU')ĭf = pd.om_records(dados, columns=) How can I do this? import gspreadįrom gspread_dataframe import get_as_dataframe, set_with_dataframeįrom rvice_account import ServiceAccountCredentialsĬredentials = om_json_keyfile_name('credentials.json', scope) I need to export two data, located in two rows of an excel column ('G7', 'G8') to two columns of google sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |