Skip to content
Advertisement

Tag: google-sheets

Gspread batch update traceback

I am having problems trying to prepopulate google sheets filter and then do a batch_update. I get correct execution, the table is imported, filters are created. When the batch update occurs, I get a traceback that I don’t understand. I thought that the traceback may have come from the way I coded the sheetId. If anyone has some wisdom on

Unable to insert 2d array within gspread

I’m trying to insert a 2D array in order to get two columns inserted into a sheet via gspread. I’m able to insert the individual lists fine, but inserting the array causes an error. Here’s my code. Here’s the value of rows [[[‘$81.57’], [‘$80.91’], [‘$91.63’], [‘$91.63’], [‘$455.20’], [‘$196.90’], [‘$282.60’], [‘$146.10’], [‘$97.22’], [‘$166.70’], [‘$287.30’], [‘$237.50’]], [‘781411’, ‘781415’, ‘781412’, ‘781416’, ‘701355’, ‘701330’,

Is there a change for reading the published CSV from Google Sheets in Google Colab?

I have been using a file from Google sheets, published as CSV, and reading it with Pandas, to make the dataframe, but today stopped working here it is the error output: 2155 def read(self, nrows=None): 2156 try: -> 2157 data = self._reader.read(nrows) 2158 except StopIteration: 2159 if self._first_chunk: pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.read() pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_low_memory() pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_rows() pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows()

Get combined/merged cells value

I’m coding a new python script that need to extract data from google sheets, but there are many cells which are merged/combined, and only the top-left cell from this merge has the value. It’s important to have that value on all the merged cells. How can I do that? Python 3.8.5 + gspread 3.6.0 Note: every comment “trying to get…”,

Advertisement