burnash/gspread

getallrecords() – can there be a "rows" option to get attributes from rows, not columns?

Open

#808 ouverte le 26 août 2020

Voir sur GitHub
 (3 commentaires) (5 réactions) (0 assignés)Python (960 forks)batch import
Feature Requestgood first issue

Métriques du dépôt

Stars
 (6 606 stars)
Métriques de merge PR
 (Merge moyen 7j 17h) (2 PRs mergées en 30 j)

Description

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 to list important attributes, and then every item in the DB is listed in a column. The attributes list would have to be Column A for these sheets, not Row 1.

Describe the solution you'd like An optional argument in getallrecords() that will be able to produce dictionaries using the first column to find attribute names, not the first row.

Describe alternatives you've considered It's possible to use getallvalues() and iterate over things appropriately or create mappings. But a dictionary like the one getallrecords() produces would be much faster to work with.

Guide contributeur