gspread input preceded by single quote

user_5929781 0
Viewed 1005

i'm using the gspread module and when i try to append new row, with some values, using the code below:

sheet.append_row(['image1', '=IMAGE()'])

it inputs the values in the next available row (as expected) but in the cell that's supposed to have =IMAGE() value, it has '=IMAGE()

it is preceded by a single quote.

the first cell is fine, with image1 as intended, without any single quote.

why is that so? how do i remove it?

gspread python-2.7 google-sheets
1 Answers
  • You want to put =IMAGE() as a formula. It's not '=IMAGE().

If my understanding is correct, how about this modification?

sheet.append_row(['image1', '=IMAGE()'], value_input_option='USER_ENTERED')

or

sheet.append_row(['image1', '=IMAGE()'], 'USER_ENTERED')

References:

Although in my environment, I can use such way, if this didn't work in your environment, I'm sorry.

user_71086530
Related