Accessing data through gspread comes up blank for lists

Viewed 18

I'm experiencing this odd problem with gspread. I'm using it to access a sheet, and I want to take that data and convey it to the frontend of my website.

I put the data into a variable like so:

data = worksheet.get_all_values()

And this works, unless I try and access a cell which has what I believe to be a list in it.

sheets error

For example, data[2][5] will give "test", but data[3][5] will give nothing (instead of: "

  • Conversation practice
  • Advice and mentorship
  • Anything!").

The circled cells are the ones which return nothing. Any ideas?

0 Answers
Related