D2G uploading dataframe with ' attached to it in values

[monipip3]

When uploading dataframe into a google sheets each value appends a '

And when I search for this object ' to replace in Google sheets, Google sheet cant find / recognize it.

[monipip3]

[TheCalcifer]

Hi, same problem, any news please ?

[fkuri-meli]

if they could add the parameter of value_input_option to the upload function like this wks.update_cells(cell_list, value_input_option='USER_ENTERED') it would be great! See: https://stackoverflow.com/questions/63273092/problem-with-data-format-while-importing-pandas-df-from-python-into-google-sheet

[richbon75]

Now that the fix has been merged into the repo, is this going to get released? The latest version on PyPi is still 1.0.4, which doesn't have this fix in it. (And this is a pretty important fix.)

[sugiyama34]

I think this problem hasn't been solved.
Is there any progress..?

[mroy-seedbox]

I'd suggest abandoning df2gspread (that's what we did), when an entire library can be replaced with a couple lines of monkey patching in the actively maintained gspread lib:

    def upload_pandas_df(self, df):
      values = [df.columns.values.tolist()]
      values.extend(df.values.tolist())
      sheet.values_update(
        self.title,
        params = { 'valueInputOption': 'USER_ENTERED' },
        body = { 'values': values }
      )

    gspread.Worksheet.upload_pandas_df = upload_pandas_df

Or use gspread-dataframe instead.

[TrevorMcGuireNG]

Solution: on line 147 of df2gspread.py, wks.update_cells(cell_list) has a default setting value_input_option=ValueInputOption.raw, but it should be value_input_option=ValueInputOption.user_entered instead.