Hi I am trying to update a cell e.g. B4 given that the cell e.g. A4 corresponds to my query. I am using pygsheets library. What I have done thus far was to use cell_list = wks.find("wednesday")to determine which cell object is it in, afterwards, I am unable to retrieve the cell id given that cell_list is this: [<Cell A2 'wednesday '>].Thanks!
Asked
Active
Viewed 310 times
0
user13883454
- 41
- 7
1 Answers
0
you can do
cell_list = wks.find("wednesday")
cell_address = cell_list[0].label
each item in the list is a cell object.
Nithin
- 5,470
- 37
- 44