When using a google sheet or MS excel spreadsheet with multiple sheets within one file, does using the Google API pickup all the individual sheets in a file? Can the same mulit-sheet function be performed using a MS excel spreadsheet?
and if you need to have a private Spreadsheet ( For the standard Google Sheet method you have to Publish the Sheet and "Share" as "anyone with the link");
When using a google sheet or MS excel spreadsheet with multiple sheets within one file, does using the Google API pickup all the individual sheets in a file? Can the same mulit-sheet function be performed using a MS excel spreadsheet?
Hi, Jason.
Sorry to disappoint you, but with our plugin it is not possible in any way to have multiple tabs from one Sheet render in one table.
One table can only connect to one tab from any Spreadsheet.
For Excel files, it will only look in the first tab.
For Google spreadsheets, each Tab has a unique URL, so the URL which you provide is going to be the tab output in our connected dataTable.
-
The Google API method is basically the same in regards to the way how it connects to output the data;
it is mostly used to avoid Google Cache, ( but we have our own cache and auto-update cache feature, too)
and if you need to have a private Spreadsheet ( For the standard Google Sheet method you have to Publish the Sheet and "Share" as "anyone with the link");
-
Let us know if that makes sense. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables