Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have few files on google drive spreadsheet. Can someone kindly share a simply way of how to load the data from google drive
For example I have the same excel sheet on my drive locally and this is the loadscript for it
LOAD a,
b,
c,
d
FROM
[test.xlsx]
(ooxml, embedded labels, table is [RAW DATA]);
How do I load the same file from google drive spreadsheet?
Arif
Hi,
One alternative to loading Google spreadsheets is using a link in the following format:
This format allows you to export as xlsx. The document needs to be shared as anyone has the link can access the document.
Thank you so much @omerfaruk ! I have tried a couple solutions from various posts but only yours still work for now in 2021! My QlikView can load more than 100 lines (mine is 362 rows) from Google Sheets finally. Great Work!!!