Restriction of number of rows from import of Web file (Gogle docs)?

[Anonymous]

Hi,

I discovered that there seems to be an restriction of the number of row you can import by Web files from Google docs (spread sheet).

It only imports the first 100 rows...

I don't think I had the problem before (a year ago) and maybe this has accured after Google has upgraded their spreedsheets to a new version

Anybody else that has encoutered the same problem?

// Peter

[jonathandienst]

Hi

This might be a restriction imposed by Google on the free version of Google Docs. You may need to convert to a paid subscription to load more rows.

Just a thought, I may be wrong....

Jonathan

[Anonymous]

It is an paid subscription so it should not be any restrictions... But a good thought though...

// Peter

[Ralf-Narfeldt]

Without digging deep into it, my suspicion is that it has to do with browser compatibility. I think Google Docs spreadsheet had a 100 row limitation when launched.

There is a connector called QVSource which reads Google Docs spreadsheets.

[Anonymous]

I have had a look at the QVSource and it manages to read all the rows, but it does not do it smart enough. My spreadsheet starts with template format row and continues headlines, instructions, etc.

My actual data starts att row 5 or 6 and Qlikview handles this nicely by deleting the top rows in the import function.

This is not possible with QVSource (what I can see) and it only makes a mess of the data... it supposes that the top row is the headline.

And yes I could possible restructure the data, but I wont do that... 🙂

// Peter