Reputation: 41
I have a google sheet with a filter/query that only shows the data that verifies the filter's conditions. To retrieve the data for python I use gspread, but hiddenrows are appearing too (as if there was no filter at all).
How can I differentiate the rows selected from the ones who weren't?
I don't understand if this can work without adding more functions to gspread, or if I need to create a new function. If so, what should the function be?
Upvotes: 1
Views: 708
Reputation: 41
I found that function fetch_sheet_metadata() which is inside class spreadsheet of gspread gives out the filters and hiddenValues for each filter, which is enough to solve my problem.
Upvotes: 2