gspread
gspread copied to clipboard
burnash
Google Sheets Python API
### motive I want you to create function coloring tab . ### If Modity The Following function ``` def add_worksheet(self, title, rows, cols, color=None): # :param color: HTML color code...
get_all_records() return nicely formatted dictionaries (thanks!) **set_record()** (new feature) inset one dictionary to google sheet (values under right heading) **set_records()** (new feature) inset list of dictionaries to google sheet (values...
Apologies for any mistakes, it's my first time writing an issue on GitHub. I'm trying to get all the values from a sheet, but when using get_all_values() the returned data...
Realized that deleting multiple rows one-by-one can take an extremely long time, especially when working with sheets with 1000+ rows, or have e.g. 500+ rows to delete. I created a...
**GitHub Issues are for bugs and feature requests.** Please do not post usage questions here. For general support from the community, see StackOverflow: http://stackoverflow.com/questions/tagged/gspread Issues with usage questions will be...
Hello, Sometimes while using gspread I need to manipulate a bacth of cells from a range but to make it easier and more efficient to manipulate these cells I convert...
### Environment info Operating System: macOS 10.13.5 Python version: 2.7 gspread version: 3.0.0 ### Steps to reproduce worksheet.update_acell('B9','=HYPERLINK("google.com","Link to google.com")') cell = worksheet.acell('B9') print cell.input_value Output shows as None ###...
I have a spreadsheet where a couple columns have a data restrictions to only hold dates. If I configure my sheets to have a very specific type then how come...
I see this as a feature request on 2014 and want to know if there is any update on this request.
Hi, I'm a junior data scientist in university. I stored my data in google drive as to enable labeling from across platforms. What I notice is that gspread prepared a...
