Connect to data in web!!!

[#1]

Dear QV Experts,

Is it possible to connect to the spreadsheet placed in web & refresh periodically?

Appreciate your prompt response.

Thanks

Sasi

[Gysbert_Wassenaar]

Maybe. It depends how the spreadsheet is published on the web.

[engishfaque · Accepted solution]

Dear Sasi,

Yes it is possible.

Here is the link where from I am loading data into QlikView,

USA Counties Data File Downloadss

File Name is,

AFN01.xls

Steps:

Edit Script > Web Files > Internet File >

http://www2.census.gov/prod2/statcomp/usac/excel/AFN01.xls

> Next > Finish.

Kindly find attached App.

Kind regards,

Ishfaque Ahmed

[HirisH_V7]

Hi,

You can access Google Sheets

• Create  your Google Sheet then Google will generate a link. Copy it
• Into QlikView Script, there´s a button "Web Files", use that link to open your document

Else

load a Password protected Excel File to QlikView

Hope this Helps,

Hirish

[#5]

Thanks All for your valued suggestions.