How to access a cell value from gspread

Question

i would like to retrieve a cell value from gspread python API, however, the cell method "sheet.acell(A)" returns a value like this sheet.acell(A) i have proposed a forced solution in a way. is there a more efficient way to handle this

      def cellfinder(A):
            cell =str(sheet.acell(A))
            for x in cell:
               if x=="'":
                 f=cell[cell.index("'")+1:len(cell)-2]
                 return f

thank you

score 2 · Answer 1 · edited Jul 14 '19 at 20:24

2

I think you already might have figured this out, but in case if you didn't, it should be:

cell = sheet.acell('B1').value

edited Jul 14 '19 at 20:24

pppery

3,731
22
33
46

answered May 17 '19 at 21:35

seeker407

43
7

Its been about a year, but I really appreciate the answer. thank you – nvrthles May 17 '19 at 21:52

How to access a cell value from gspread

1 Answers1