gspread
gspread copied to clipboard
burnash
Google Sheets Python API
Hello, I was just using some lines of code like this one: wks.update_acell('A1', formula), and had worked fine. but now I'm using a different formula =googlefinance("petr3"; "price"; DIATRABALHO(HOJE();-10);HOJE()). But the...
I'm using gspread as driver for storage for items from scrapy spiders. And there is many items from one job, so gspread takes a long time to write them all....
I haven't found any "lightweight" versions of the `get_*` methods, i.e. methods returning iterators or generators on the results. This makes reading a large spreadsheet memory-intensive. Is there any specific...
We can use [Google Query Language](https://developers.google.com/chart/interactive/docs/querylanguage) to query the content of Google Sheets. It's a subset of SQL and I think it's much more flexible than the current `_finder` method....
Hi @burnash , i am using python 3.7.1 with **gspread** library version 3.1.0. I tried with gspread 3.6.0 but it is the same issue. Until the 17th of May 2020,...
**Is your feature request related to a problem? Please describe.** Sometimes I have to work with spreadsheets that are "rotated 90 degrees" – that is, the creators use the rows...
Apparently, there is a couple of bugs on calculating the range of cells that need to be updated through update_cells. First of all, it assumes the cells are sorted and...
Currently, when you read from a spreadsheet that has merged (combined) cells, the value is only kept for the first of the individual cells that compose the merged cell. It...
I would love to take a stab at creating a move_row function. There is sufficient [documentation](https://developers.google.com/sheets/api/samples/rowcolumn#move_a_row_or_column) in the existing Sheets v4 API. There are all sorts of uses cases where...
hi there, I needed (and implemented) a parameters propagation feature for range. The use case is pulling formulas or (un)formated text through valueRenderOptions. Janis
