How to load data from google docs spreadsheet?

[#1]

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

[#2]

open the spreadsheet with the internet explorer.

go to the script editor and clik on web file paste the url of the spread sheet.

thats one way

have you try to download the gdocs app and syn the drive with a file in your local computer?

[#3]

I have tried to click on script editor and then clicked on spreadsheets, but which URL do I past and in what format in Qlikview?

[marcus_malinow]

Hi Syed,

this is actually pretty easy though there are a couple of slight issues.

In your script editor, click on the 'Web Files' button. Enter the URL of your google spreadsheet.

In the dialog you'll need to select table '@2'

Note that you can only reference the first sheet in a google doc. If you want fuller functionality you'll probably have to use a product such as QVSource.

Marcus

[#5]

Can't see the webfiles button. Can you please share a screen and highlight it?

Syed

[marcus_malinow]

Syed, it's in QlikView, in the Script Editor. It's at the bottom in the 'Data' tab.

[#7]

ohh that was a bit stupid of me lol. Many thanks. Yes, it is working. One last question though. Even the embed lables are not taking the first row as lablels. In excel, If I select embed lables, it takes the first row as labels. Why is it not taking the first row as labels?

[marcus_malinow]

Basically because it's a bit rubbish

Try using this in the parameters to remove the top row:

(Remove(Row, Pos(Top, 1)))

[#9]

Sorry one more question. What do I need to do to reload the same script on another machine or on a client computer?

Syed

[marcus_malinow]

Shouldn't need to do anything at all, as long as your machine has internet access.

Only issue might be if the document is secured, in which case you're going to run into issues.

If you need the document to be secured, then perhaps the Google docs sync app might be the way to go.