Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Import xlsx with more than 64k rows - QV 9 last release

Dear all,

I'm trying to import an excel spreadsheet (xlsx) with about 500k lines.

It does not work, but only shows up an error in allocation of memory.

Thank you for your help in advance.

I'm using Qlikview 9 in the last Release, Windows XP, 4GB Ram

Tags (2)
1 Reply
deepakk
Valued Contributor III

Re: Import xlsx with more than 64k rows - QV 9 last release

hi,

Can you attach  the file, we can check it our end.  Also try the following activites.

1) load one field at a time and check which field is causing the problem.

2) try to increases your virtual memory.

If you are able to load the data then store it in Qvd. (Loading from qvd will be much faster.)

Deepak

Community Browser