Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

danielrozental
Honored Contributor II

Google Spreadsheet reloads fail with QV11

A customer has a problem loading Google Spreadsheets through Publisher, it works fine in the QlikView Developer, and it also worked fine in QV10 both in the developer and in Publisher.

It's not a permission or an environment issue as we're able to replicate the issue everywhere.

Here's the code for you to test it out

LOAD COLUMN1,

     COLUMN2

FROM

[https://docs.google.com/spreadsheet/ccc?key=0AuvOXv8gND60dGVyUjlWb0FUMUd5dHdIb2lJenltOGc&output=xls]

(ooxml, embedded labels, table is Sheet1);

Any ideas or workarounds are welcome (hopefully without involving purchasing a connector).

1 Solution

Accepted Solutions
Not applicable

Re: Google Spreadsheet reloads fail with QV11

Daniel, I have just found a fix for this

In Google sheets you need to publish the document and then use the published URL.

Hope this helps

2 Replies
Not applicable

Re: Google Spreadsheet reloads fail with QV11

Daniel, Did you ever get a solution to this?

Not applicable

Re: Google Spreadsheet reloads fail with QV11

Daniel, I have just found a fix for this

In Google sheets you need to publish the document and then use the published URL.

Hope this helps

Community Browser