search

turbot / steampipe-plugin-googlesheets

Use SQL to instantly query spreadsheets, sheets, and cell data from Google Sheets. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/googlesheets
Apache License 2.0
31 stars 0 forks source link

no ranges defined in sample spreadsheet? #8

Closed judell closed 2 years ago

judell commented 2 years ago

The main example is:

select
  sheet_name,
  cell,
  value
from
  googlesheets_cell
where
  range = 'Students!1:1';

This finds nothing because there don't appear to be any named ranges in the sample spreadsheet.

However I added a range to a different spreadsheet and it indeed works, very cool!

This actually does work but I'm not sure how. I don't see any ranges in the sheet, and select range from googlesheets_cell finds only nulls. Oh, I think I see. In the WHERE clause, range is dynamic, the range column is only populated when there are named ranges.