getallrecords() – can there be a "rows" option to get attributes from rows, not columns?
- Dominant language
- Python
- Stars
- 7.5k
- Forks
- 979
- PR merge metrics
- No merged PRs in 30d
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.
Contributor guide
Research direction
Start by locating the getallrecords() and getallvalues() entry points and reading how they interpret spreadsheet rows and columns. Define the optional orientation behavior from the issue, then verify that rotated sheets produce dictionaries keyed by the first column while existing row-based behavior remains unchanged.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- api, data
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100