search

burnash / gspread

Google Sheets Python API
https://docs.gspread.org
MIT License
7.04k stars 943 forks source link

How to skip hidden rows while iterating through Google Spreadsheet #710

Closed eosfomogame closed 2 years ago

eosfomogame commented 4 years ago

https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#isrowhiddenbyuserrowposition Is it implemented?

lavigne958 commented 4 years ago

I don't see it implemented in this repository.

the link you point to is about google appScripts which do a similar job but embedded code on google servers in javascripts, if you want details about what informations can be retrieved from the spreadsheet API look at this section: sheet section on the left side you have the other sections (cell, ...) have a look if you find what you are looking for.

snusnuz commented 4 years ago

Hello, I'm also interested in having this feature. Unfortunately I'm a Phyton newbie and I only tried to make some changes to the models.py, with no luck.

Can anybody point me in the right direction in order to find a way to implement sheet.isRowHiddenByUser(row)?

JonB451 commented 3 years ago

Is the question here:

Can gspread recognise which rows are HiddenByUser?

lavigne958 commented 2 years ago

I looked on the API reference and could not find anything about this. Hidden row are simply not available from the API :disappointed: