Open hkalexling opened 5 years ago
I'm really sorry for the late reply. Yes, I think this is a good idea. Let me know if you are still interested in submitting a PR.
@burnash Has anyone submitted a PR for this? If not, can I work on it and send a PR?
@ruchit2801 as far as I know, there's no PR for this. If you're interested, please go ahead.
We can use Google Query Language to query the content of Google Sheets. It's a subset of SQL and I think it's much more flexible than the current
_finder
method. All we need to do is just sending a GET request tohttps://docs.google.com/spreadsheets/d/[id]/gviz/tq/tq=[query]
.Here's a simple example where we query all the records in this test spreadsheet with age larger than 50:
The only drawback that I can think of is that we can only get the table content, but not the row/column indices, but I think it's good to have this option there for users need it.
@burnash If you think it's a good idea, I would be happy to submit a PR.