How to extract data from an excel file on google drive

Sun, 29 Nov 2015 09:37:01 GMT

Hi All,

I am trying to link my excel sheet to my dashboard, my excel sheet is on google drive and I have set the permission to public.

But qlikview cannot access the file and is giving this msg.

Any Ideas?

Re: How to extract data from an excel file on google drive

Gysbert_Wassenaar — Mon, 30 Nov 2015 07:35:40 GMT

Then the link you have is not the download link. If you open that link in a browser you'll probably see a preview version rendered in html. And there'll be a link somewhere on that page to actually download the real xlsx file. If you use that link in qlikview then you will be able to retrieve the data.

This one doesn't work: https://drive.google.com/file/d/0B9CnVNY_TWtTYUF2RU91SUhpVVk/view?usp=sharing

But this one does: https://doc-0c-60-docs.googleusercontent.com/docs/securesc/ha0ro937gcuc7l7deffksulhg5h7mbp1/hci5f4gq8q3bu36njsbi6sshvk1cjgk1/1448863200000/10226325898574733077/*/0B9CnVNY_TWtTYUF2RU91SUhpVVk?e=download

T1:

LOAD Dim1,

Dim2,

ID,

FROM

[https://doc-0c-60-docs.googleusercontent.com/docs/securesc/ha0ro937gcuc7l7deffksulhg5h7mbp1/hci5f4gq8q3bu36njsbi6sshvk1cjgk1/1448863200000/10226325898574733077/*/0B9CnVNY_TWtTYUF2RU91SUhpVVk?e=download]

(ooxml, embedded labels, table is Sheet1);

Re: How to extract data from an excel file on google drive

Mon, 30 Nov 2015 08:13:03 GMT

Thank you Gysbert, it is working great now.

topic Re: How to extract data from an excel file on google drive in QlikView

How to extract data from an excel file on google drive

Re: How to extract data from an excel file on google drive

Re: How to extract data from an excel file on google drive